MySQL Backup - seems a little quick?

theMAD2 · 16 Mar 2006 at 12:47

I've just run a backup of my MySQL database using a piece of software called Navicat and it seems to be very quick, is this normal? I have Joomla! and phpbb, and Joomla has about 250 news items, and the backup is taking about 10 seconds lol. Is this normal?

Thanks,

Adz · 16 Mar 2006 at 12:53

Are you sure you're backing up the data and not just the structure? In any case, it's just plain text, the only thing you have to wait for is the server to output the dump. Take a look at the back in a text editor, ctrl + f for a record you know should be there. Repeat 5 times then relax, safe in the knowledge that your backup is complete

.

theMAD2 · 16 Mar 2006 at 13:17

I think it is, I'm just so surprised how quick it is. It says in the backup bit "note: this will only backup tables and their data. queries and reports are not included", am I safe enough with this?

Adz · 16 Mar 2006 at 13:30

theMAD2 said:
I think it is, I'm just so surprised how quick it is. It says in the backup bit "note: this will only backup tables and their data. queries and reports are not included", am I safe enough with this?

Yup, sounds good to me

.

theMAD2 · 16 Mar 2006 at 13:35

That's great! Thanks mate

ByteJuggler · 16 Mar 2006 at 17:26

theMAD2 said:
That's great! Thanks mate

You should test the backup to be sure it is what you want.

theMAD2 · 17 Mar 2006 at 08:50

You should test the backup to be sure it is what you want.

*Gulp* I might have to test this with another database first. How does everyone else backup their MySQL?

roboffer · 17 Mar 2006 at 09:01

Through Enterprise Manager. Backup and restore through there, although thats due to me having access to the servers. If I didnt, I ouldnt have the foggiest.

Crazy Squirrel · 17 Mar 2006 at 09:07

theMAD2 said:
*Gulp* I might have to test this with another database first. How does everyone else backup their MySQL?

Daily out of hours backup of the data directory plus a daily dump using mysqldump.

mysqldump DBNAME -uUSERNAME -pPASSWORD > FILENAME

mysqldump doesn't backup in the conventional way but creates a text file with the 'create table' and 'insert into' lines necessary to restore the tables from scratch. Currently about 20seconds to produce a 12mb file.

theMAD2 · 17 Mar 2006 at 09:08

Would that be a .sql file?

Crazy Squirrel · 17 Mar 2006 at 09:10

theMAD2 · 17 Mar 2006 at 09:20

Ok cool. I've just been looking at my navicat program (http://www.navicat.com/detail.html) and I think it's ok, the website seems to say it's a proper backup. Sorry for the strange questions, do you think it's worth getting?

topbanana · 17 Mar 2006 at 11:18

Restore onto another box to be sure

Crazy Squirrel · 17 Mar 2006 at 14:16

Seems like a more managed backup solution, never used it myself. Personally mysqldump does what I need I don't think this thing would help me, hardly every have a problem with mysql anyway (touch wood).