MySQL Database Backup

[BernardBlack]

Hello there,

For the MySQL Database Backup, if I download those files (from the links under Cpanel > Backup > Download a MySQL Database Backup) I can have something go wrong and lose the tables / everything, and I can get my website back up? (I have the files in the folders on my computer anyway - just not mysql databases) By restoring?

When I download my mysql backup the file downloads instantly (never happens for me) and was less than a kB, but it seemed to have everything in it (I hope), but for my forum's mysql backup, it only downloaded a few lines of code (after viewing in notepad) - when there is over 10 000 posts that should be there... or does IPB save to files?

Thanks for your help in advance.

[Frank Broughton]

There is a setting for the size of the file I believe. Set it for a bigger size.

Under data: Maximal length of created query

[BernardBlack]

There is a setting for the size of the file I believe. Set it for a bigger size.

Under data: Maximal length of created query

Where would this be found?

[Frank Broughton]

in PHPMyAdmin -> Export page -> lower right corner....

[BernardBlack]

It is currently set at "50000" and the file is less than one kB that I download. I am still uncertain if the posts from my Invision Power Board forum is stored in the mysql database or in actual files / HTTP?

Thanks.

[GolfVN]

Its in database. Something is wrong.
Did you select all the tables in the export page?

[Vin DSL]

I don't mean to be a wise-guy... but why don't you just bypass the kiddie version of phpMyAdmin in cPanel -- and install phpMyAdmin in your own web space? That way, you won't have these limitations...

I can install phpMyAdmin on JagPC, from scratch, in about 5 minutes -- so, it might take you an hour (the first time). It's really no big deal, then you can use it to backup your MySQL dbs!

[Vin DSL]

It is currently set at "50000" and the file is less than one kB that I download. I am still uncertain if the posts from my Invision Power Board forum is stored in the mysql database or in actual files / HTTP?

I haven't used IPB in a while, but I cannot imagine them storing any data outside of the sql db...

Most of these PHP bulletin boards use the same code. They just rearrange things differently, you know?

It's not like they can invent some proprietary PHP function, or whatever.

[Vin DSL]

Heh!

Just upgraded from phpMyAdmin 2.9.2 to phpMyAdmin 2.10.0-rc1

http://lenon.com/phpMyAdmin

Took me 9 minutes -- mostly uploading it to the server, and deleting old files...

[Rob]

IPB stores all post and thread data in a SQL Database field called Ibf_posts and Ibf_topics. You can download a database backup from your ACP if your running version 2.1 and up

[Saint]

IPB stores all post and thread data in a SQL Database field called Ibf_posts and Ibf_topics. You can download a database backup from your ACP if your running version 2.1 and up

Rob beat me to the answer, but yeah what he says is correct. I believe there is a way to do it on lower versions as well if needed.

[Rob]

i wasn't sure if there was a database backup tool for versions below 2.1... so i said 2.1 and above

I think there is a backup tool for 2.0 as well

[loki1023]

You could also check out mysqldumper mate I use it to create twice daily backups of all our databases and ftp them off server to a server I have setup on my home network ,but if you don't have an offsite ftp server to use you can also have them emailed or just stored on the server.

Anyway if your intrested in mysqldumper there is a nice thread on the jpc forums to walk you through the installation Setting up mySQLdumper of a JaguarPC Server

[Vin DSL]

phpMyAdmin FTW!!!