MySQL Database/Backing up adn empty tables

Posted: Tue Jan 28, 2003 11:27 am

I gots a couple questions guys.

With MySQL database on a few of my sites, our DB is over 7 MB.
I am unable to backup the DB at this size using the backup thru Nuke's Admin OR phpMyadmin.
The only way I can backup the DB is to go into phpMyadmin and select about a third of the tables at a time to backup, thus splitting my backed up DB into 3 files.
On one server when trying to Backup through Nuke's Admin. We get Internal 500 Server error. ON another host we get This page cannot be displayed.

Anyone else experience this?

My other question. Are there any tables in the nuke MySQL Database that can be emptied in order to size the DB down a little without having ill-effects?

mikem

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

http://computercops.biz has over 300 megs for its sql database size. I never use the phpnuke backup or phpmyadmin. I go directly into the server and run mysqldump:

mysqldump -u $dbuname --password=$dbpass $dbname > sqlbackup012703.sql &

Its so large, that it takes a long time to actually backup into a file so I send the process into the background.

Posted: Tue Jan 28, 2003 1:06 pm

Sounds great, but without shell access backing up with that method is out for us.

mikem

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

If you don't have shell access, then why not take that line and enter it into a PHP exec call? Force it to the shell from your browser.