UBB.Developers Forums Community Development Programming MySQL and Server Configuration MySQL

OK, anyone know where this thing stores the posts? I'd like to specifically back up the board without backing up the whole machine.

Michael,

you should take a look at phpMyAdmin at http://www.htmlwizard.net/phpMyAdmin/, which is very useful to view, edit and dump the mySQL tables.

Carsten

--
Carsten Müller, Hamburg (Germany)

Considering you asked almost a year ago, you may not need to know anymore. heh... instructions for backing up your mysql database are at the following:

http://www.wwwthreads.com/support/maintenance/backup/index.html

- Six
[email protected]
mYth productions

Here's the CRON script I use.

[]http://www.amdragon.com/images/eileensig.gif[/]

Thanks Eileen! I'll get that into the support library. []/w3timages/icons/smile.gif[/]



- Six
[email protected]
mYth productions

Backup Database from the prompt-

mysqldump -u(databaseusername) -p(databasepassword) (databasename)>backupfile.sql

Example-

mysqldump -uocsfoundation -ppassword forums>forumsbackup.sql

This is the best way to do it and you should not rely on phpMyAdmin since it will sometimes not do it right and you will be unable to re-import it later, or with a lot more effort ;-)

Learned this the hard way ;-)

-Jason