mySql backup/restore function?

sid

ok - here is my problem...

i have 2 big pages - and one of them will have to move to a new server - right now i do not have any problems, since i use cpanels backup/restore feature to take care of the webspace content as well as the db content.

the database has about 10 mb right now - with cpanels backup script i can download this as a handy 5mb tar.gz archive and restore it with the same script just as easily.

my new server might not have that script though. phpMyAdmin backups of that db are about 20 MB big - usually no problem for the download part (usually...) but when you try restoring a 20 mb db with phpMyAdmin - well - lets say it like that - it never worked for me...

i have to divide the file into chunks of 1,2 MB MAX - otherwise the server times out guaranteed when i try restoring it. this is a.) very unhandy and b.) whoever worked with a 20 MB textfile before knows how much fun it is to edit a file of that size...
the page is still growing, so the db will as well...

so in case i am moving the page to a server which does not provide me with the cpanel backup feature: does anybody know of any other scripts that work in a similar way? i would need that for the db as well as the webspace itself (and if possible the email aliases)! how about the backup features of plesk and ensim - any good?
i would be thrilled if you could suggest me some nifty scripts...

thanks a lot in advance!

sid

matjaz

tok tok 🙂

1st - most of php "upload" things use default php.ini setting where post wont accept data > 2MB. you can easily override that with ini_set.

2nd - upload limit/size is usually set to 8MB... again, ini_set if you need to upload bigger chunks.

i know phpmyadmin problems when doing backups & restores. never works well.

go to shell [telnet] and do mysqldump. fantastic thing...

mysqldump database_name > mydump.txt

and here you have your DB dump. now just gzip it and you get mydump.txt.gz... thats your backup. when you want to restore, unzip and do:

mysql database_name < mydump.txt

simple, ha?

check mysqldump options. i usually add --add-drop-table -c [complete inserts]... something like that.

if you need more help, ask! 😉

sid

thanks a whole bunch... cn i contact you in case i need that stuff again and need assistance? that'd be awesome...

rock on - sid