Backing up the database.

[TheJkWhoSaysNi]

YaBB SE Version:
PHP Version:
MySQL Version:
Server Platform:
Link to Forum:

Problem Description:
Ok, I used the dump feature in YaBBSE and realised that it doesnt backup the posts, so i tried phpmyadmin, but it always downloads a 0byte zip or gzip file it used to work fine from phpmyadmin, i'm guessing its because of the size? The posts table just seems too big! I cant even back it up on its own! How can i back up the posts? Thanks.

[Douglas]

First, run a repair on the entire database with phpMyAdmin, then Optimize it.

Once you do that, come back and let us know how large your database is.

It may be easier for you to do this manually via a Shell command:

mysqldump -uUSERNAME -pPASSWORD databasename > filename.sql

Change USERNAME and PASSWORD (but not the leading -u and -p) to your MySQL username and password.  It IS case sensitive, so an "A" is not the same as an "a".  Same with the database name.

If you still need help, and/or want me to handle this for ya, PM me the specifics.  

[TheJkWhoSaysNi]

How would I go about running a repair? Thanks.

[Douglas]

That's built into the latest versions of phpMyAdmin.  Select your database.  click on CHECK ALL, select REPAIR in the drop down menu.

[TheJkWhoSaysNi]

I guess the version of phpmyadmin that my host has installed isnt that new then. I'll upload the new version myself later. Thanks.