How big is your database?

Lieutenant Joined: Dec 30, 2003 Posts: 283

OCSupertones wrote:

Is there a better way to backup than with the admin panel?

The other way is to directly TAR the mysql directory. This is my preferred approach for batch backups.

Here is a thread.

http://www.webhostingtalk.com/showthread.php?s=&threadid=229372&highlight=tar+mysql+backup

Nuke Soldier Joined: Sep 28, 2004 Posts: 11

Yes that is an excellent way to backup and restore from the shell, and there is even a way to put this command into php using the system() php command.

Nuke Soldier Joined: Sep 16, 2004 Posts: 10

mine is over 600Mb... the nuke admin backup or php my admin won't work well because of the size.

The best way is via ssh using Putty. Here's the process:::::

If you have access to SSH (or telnet will work, though use ssh not telnet as ssh is encrypted) you can do everything you need to right from the command line.

to get a dump of you db, connect with ssh, then you simply need to type:
mysqldump -u yourMysqlUsername -p DBNAME > filename.sql (hit enter)
you will then be prompted for your password

you are done Smile

there should now be a file called filename.sql with all your structure and data.

Alternate syntax:
mysqldump -u yourMysqlUsername -pPASSWORD DBNAME > filename.sql (hit enter)
(the no space between -p and PASSWORD is not a typo)

mysqldump --user=yourMysqlUsername --password=PASSWORD DBNAME > filename.sql (hit enter)

you can also add more db names on and dump more then one at a time, but I think one at a time is better. one db per file that way.

Captain Joined: Jan 03, 2004 Posts: 501

3.08 MB

Posted: Tue Apr 18, 2006 10:57 pm

www.canadaka.net/forums

345.89 MB

Posted: Tue Apr 18, 2006 11:30 pm

I just backed up a 120Mb database. Using phpMyAdmin, trying to save the file as a zipped or gzipped file didnt work. However I was able to download the uncompressed file. BUT phpMyAdmin would not allow me to reinstall such a big database. I used bigdump and was able to reinstall with no problems.

Sergeant Joined: Jul 11, 2004 Posts: 104 Location: Athens

I am glad we decided to host our site from home. Looks like it can be a pain to backup from a host.

I use phpmyadmin for the backup and it's about 85mb. To restore I sftp intot he server and dump the sql file in the root dir then ssh and restore from.

Lieutenant Joined: Sep 13, 2003 Posts: 296

My backup is 21 MB, but gzipped. I use MySQLDumper, both for backup and restore. It is ideally suited for large backups like mine.

http://www.mysqldumper.de/en/

Nuke Cadet Joined: Feb 19, 2007 Posts: 1

after reading on this mine is pretty small 5.9mb zipped lol

Sergeant Joined: Feb 04, 2004 Posts: 100

mine is pretty large as well (450 MB) PHPnuke and my server aren't handleing the size well.