473,320 Members | 1,817 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

mysqlhotcopy problem

alright, heres the problem, I setup a backup routine to backup my
daabase at night under another name and then do a dump on that backup
database so that my users can still acces the site while I do the dump
on teh backup database.

it works, however it seems that, even tho I delete the directory after
im done, that the next day the data in the backup database I then use
to dump is the same as the one from the day before, even tho the main
database I asked to backup changed.

heres my backup procedure:

cp /root/backup/mysql.mysqlDB.txt /root/backup/mysql.mysqlDB.txt.bak
mysqlhotcopy --user=root --password=L0veD0me --allowold mysqlDB
mysqlDB_backup
mysqldump --add-drop-table --quick --user=root --password=MyPass
mysqlDB_backup /root/backup/mysql.m
ysqlDB.txt
rm -rf /var/lib/mysql/mysqlDB_backup

so yeah I noticed that mysql.mysqlDB.txt had same size as
mysql.mysqlDB.txt.bak today wich is impossible considering I get 200+
new record a day in my members table.

hope someone can help,
thank you

Aug 16 '06 #1
0 2364

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Moritz Steiner | last post by:
------_=_NextPart_001_01C34A15.850E4CF5 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Does mysqlhotcopy work with innoDB? I only get it to work with...
0
by: Vladimir Shiray | last post by:
How can I make hotcopy of my database if it have many tables (more than 1000) ??? mysqlhotcopy failed when it try to lock all tables ... How many tables can I lock at one time ? Can I increase...
0
by: Brian | last post by:
Hi, I'm trying to script a backup program using mysqlhotcopy. I've got the script in /root/ and i'm calling mysqlhotcopy from there. I can get the script to work if i pass the password on the...
117
by: Peter Olcott | last post by:
www.halting-problem.com
28
by: Jon Davis | last post by:
If I have a class with a virtual method, and a child class that overrides the virtual method, and then I create an instance of the child class AS A base class... BaseClass bc = new ChildClass();...
6
by: Ammar | last post by:
Dear All, I'm facing a small problem. I have a portal web site, that contains articles, for each article, the end user can send a comment about the article. The problem is: I the comment length...
16
by: Dany | last post by:
Our web service was working fine until we installed .net Framework 1.1 service pack 1. Uninstalling SP1 is not an option because our largest customer says service packs marked as "critical" by...
4
by: pankajit09 | last post by:
Hello I want to know about mysqlcump and mysqlhotcopy . Which is better and why ? If mysqldump is there then why mysqlhotcopy is developed ?
2
by: Antoni | last post by:
I tried using mysqlhotcopy to do backup copies of my databases, but it fails with error: "DBD::mysql::db do failed: Not unique table/alias: 'comments' at /usr/ bin/mysqlhotcopy line 466." Has...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.