Backup for database

[Anat]

I think it's time I started doing some backups for the TCS forums. The Vbulletin manual tells you to:



To back up your data, you can use the MySQL dump tool. If you are on a UNIX machine, the syntax will be this:

mysqldump <dbname> > /forumbackup.txt



Has anyone tried this thing already? where do I put this syntax? Do I telnet the server or is there a place on the administrator panel?

[werehere]

Yes, I backup regularly using telnet. You can also use phpmyadmin but then you will be limited by the max execution time limited by your php.ini file.


So in telnet you would use:

mysqldump dbname > /path/to/your/directory/forumbackup.sql

Or you may need to use your mysql username and password:

mysqldump -uusernameme -ppassword dbname > /path/to/your/directory/forumbackup.sql


There is no option in the admin control panel, but I believe it will be there in version 2.0.

Telnet is really the best, and fastest way to do this.

[jamesglewisf]

Wow! Great first post werehere! BTW, Anat, werehere has an incredible site called http://www.were-here.com that you ought to check out. They have great technical forums.

[Anat]

Thanks werehere!

I think you know by now that I used your advice and Chris's and I have a backup copy!

I hope they will have this option in the admin control panel. These UNIX commands are not very user-friendly...:) I think Vbulletin should at least give a more detailed explanation in the manual.

Thanks again!

I'll go check out your site now :)

[werehere]

Oh thanks guys! :)

Yeah, it would be nice to have that option in the control panel for new users (and it will be in the next version I believe).

Keep in mind that the more you use those commands the better you will understand how to control and tune your mysql and speed up your forums! ;)