Backup with PHPmyAdmin. How to?

[Parker Clack]

After reading about the database getting corrupted at times I am wanting to know how to back it up. It is recommended to use PhpmyAdmin but I don't have the first clue how to do this.

Any help would be appreciated.

Parker

[eva2000]

same here i just started with vbulletin and am don't know how to install phpmyadmin and use it to back up a database.... i mean i downloaded 2 compression types of phpmyadmin.... .gz and winzip

i am on a red hat linux 6.2/apache with mysql/php3

[SonnetCelestial]

Actually the best way to do this is through a cron job (aka automated script run at certain time intervals)

I just lost my database due to corruption and I HIGHLY recommend doing a daily backup.

[Parker Clack]

SonnetCelestial

I have no clue how to do this.

I am an idiot when it comes to doing this sort of thing. How would you tell someone like me how to do this.

Parker

[eva2000]

how do you do a cron job ? i use webmin to admin my server and can setup cron jobs... i am completely confused :confused: ?

[ey143]

I am worse than you guys, what is a cron job?

I thought this program is stable, why should the db get corrupted?

Please explain backup procedure in simple english.

Thx

[goldenheart]

well? anyone got any ideas?

[wajones]

I have over 20 years expierence as a Network System Administrator and Oracle database administration. To make this story short I got hold of the new version of PHPMyAdmin, wasn't wearing my glasses right! Fired it up, I thought the buttom said "DUMP Database" I thought Allright! Clicked the buttom and even answered "Yes" the "Are You sure you want to DROP Forum database" and just like that it's gone!!!! No backup... Luckily I'm just putting it up and I have no users, however I've done day's of work customizing the templates and adding fields etc... Moral of this story.... Back it up! Be really careful, no matter how much expierience you have, it or you will eventually screw up!

Now to not know and to ask is not being an idiot, to assume you know and screw up like I did is being an idiot!!!

You can visit http://www.phpwizard.net/projects/phpMyAdmin/ to pick up PHPMyAdmin, if you installed vBulletin, it's easy to install... it comes with complete instructions, but it's really easy to screw up if your not careful, I bear witness to that fact.

[goldenheart]

Well guys, If you still need to know, heres a link that will tell you how.

http://support.websiteproviders.net/databases/mysql-backup.html

[M. Libbert]

I find this to be a major source of confusion for me as well. When I go to the site http://www.phpwizard.net/projects/phpMyAdmin/ it is scant on instructions on how to install this, or how to use it once it is installed.

I am a real novice when it comes to server administration and MySQL. If someone could tell me in simple terms is it necessary to back-up the database if your account on your server is being backed up daily?

If it wise to do so, could someone clue me in on where I can get some concise clear step by step (for dummies type) instructions on how to do this. I have read all of the posts above and it all seems greek to me. UBB may not have as many frills, but it least it fairly easy for me to understand.

[goldenheart]

use the above link , its comphrensive, think about it for a while if it dosent make sense to you straight away.

[goldenheart]

I mean this link:
http://support.websiteproviders.net/databases/mysql-backup.html

[wajones]

I used the latest version of PHPMyAdmin I made a dump of my database (Changing Hosts) did a full database dump.

Set up my new MySql database on the new host ran the dump.sql sqript within PHPMyAdmin to import the data. "CRASH" everytime. Ran it on my old host "CRASH" evertime. I did accomplish a restore by running bits and pieces of the process and eventually had success. Now this was with no users or threads, only changes from stock was a few custom templates I wanted to preserve. No big losses but it makes me afraid to rely on PHPMyadmin for backup of the entire forum. Probably if you do each table separately you will have better luck. My new forum will be at http://oldamigos.com Not complete as of yet.

Has anyone have a better idea.

[wajones]

I found what looks like a nice script to backup vBulletins database, you can find it at http://www.kill-9.dk/PHP-Dump.php now to have someone write a restore script.