Page 1 of 1
Transfer databases
Posted: Sun Oct 06, 2002 6:57 pm
by ace2600
I'm changing host and I need to know how to backup and upload my database to my new host. My current host allows me to back up the db as a .gz file and upload, i'm not sure if this some universal file I will be able to upload to my new host or not. If not how should I go about transferring my db to my new host? Prob doesn't matter but its 2 tables containing 60 records and 25 records. I'm using MySql v3.23.45 and PHP v4.2.1. All help is appreciated.
-Ace
Posted: Sun Oct 06, 2002 8:01 pm
by evilmonkey
Hello. If you made a back-up, that means you have PHPmyADMIN (I assume you have it on both hosts). If your .tar.gz file does not open on your computer with winzip, you need to get winrar (
http://www.rarsoft.com). Is is just like winzip, except it works with diffrent extensions. You don't have to pay, just download the trial version. It works for 30 days.
Now, you have opened the file and extracted the file within. Now eveerything is simple. Go into the PHPmyADMIN on your new host and click your database on the left. Under the "Run SQL quesry" box, you will see a small box. Above it will say "Or location of thhe text file". Go to "Browse" and point it to the document you have extracted from the .tar.gz file. Hit the "Go" button and everything should be okay. Your old database will now be imported.
Best of luck to you.
Posted: Sun Oct 06, 2002 9:06 pm
by ace2600
great, so I just need to extract it with winrar and follow the steps. Off curiosity is their an sql statement for backing up or uploading a database or a table?
Thanks
Posted: Sun Oct 06, 2002 9:18 pm
by evilmonkey
To answer your question, no and no
If you change the file you extracted to 'something.txt', you will see SQL syntax. All is does is it passes that syntax and creates tables and records identical to the ones you had in your previous database. Hope this answers your question.
Good luck.