UseBB Community

i want to ask how to make and to restore database?

If you have cPanel access(control for domain you own).

To download backup, just click backup and click database you want under "Download a MySQL Database Backup" downloads to where ever you choose.

To do restore, click browse under "Restore a MySQL Database" to get file and then click upload.

cPanel is provided with a hosting account(allows you to control your site), forgot to add that(can not edit above).

You can also use phpMyAdmin to export the database or use mysqldump.

to: dietrich
i am sorry i still newbie in phpmyadmin can you please decribe step by step please ... (if possible by screen shot maybe ? )

to : william i never using backup facility in cpanel ... can you describe .. step by step please? i am very sure it will help others too

i hope in the next UseBB version there also integrated facility to make and restore database to .. thanks..

nike wrote

to : william i never using backup facility in cpanel ... can you describe .. step by step please? i am very sure it will help others too

Best I can do been posted above.

never mind william ;p

now i know they way .... i tray to backup using Phpmyadmin.
to restore it , i just delet the database..... make the new one with same name (now the database is empty) and then i restore the database.

maybe it`s not the good way .. but it works !
i prefer using phpmyadmin ... since i can restore the mysql to other server.

If you have shell access the following is the best way to do this.

To make a backup issue the following command:

mysqldump --opt -Q -u databaseusername -p thedatabasename > /path/to/nameofthebackup.sql

To restore use this command:

mysql -u databaseusername -p thedatabasename < /path/to/nameofyourbackupfile.sql

if the database is on another server add "-h theservername" (with out quotes) to the commands