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
Transfer databases
Moderator: General Moderators
- evilmonkey
- Forum Regular
- Posts: 823
- Joined: Sun Oct 06, 2002 1:24 pm
- Location: Toronto, Canada
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.
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.
- evilmonkey
- Forum Regular
- Posts: 823
- Joined: Sun Oct 06, 2002 1:24 pm
- Location: Toronto, Canada