I just got a new host and I wanna transfer my databases, or at least the tables into the new DB. Both hosts use phpmyadmin. I wanna make sure the tables are all there and set up before I transfer the domain name there and the site not work.
any tutorials on that?
Transferring Databases
Moderator: General Moderators
-
punkandjunk
- Forum Newbie
- Posts: 8
- Joined: Thu Jul 17, 2003 12:07 am
- Location: Jackson MI
I'm not sure there are any of those (anyone might want to write one?), but it's really very simple, at least if you have the opportunity of using same tools as I.
Either phpMyAdmin
1. Select your database in the left frame.
2. In the right frame, click 'Export'.
3. Choose (using an example) your tables, and 'SQL', 'Structure', 'Data' and 'Save as file'.
4. Press Go.
5. Connect to your other source.
6. Press 'SQL' in the right frame.
7. Choose the location of your previously saved file (or paste the contents of it). Remeber to choose the correct compression if any.
8. Press GO. Voilá.
Other options is using the MySQL-Front software (Win32, GUI based). In this software there are a Im/Export menu, that easely will guide you in the process (supports server to server exporting).
Good luck, hope it helped.
Mysql-Front
phpMyAdmin
Either phpMyAdmin
1. Select your database in the left frame.
2. In the right frame, click 'Export'.
3. Choose (using an example) your tables, and 'SQL', 'Structure', 'Data' and 'Save as file'.
4. Press Go.
5. Connect to your other source.
6. Press 'SQL' in the right frame.
7. Choose the location of your previously saved file (or paste the contents of it). Remeber to choose the correct compression if any.
8. Press GO. Voilá.
Other options is using the MySQL-Front software (Win32, GUI based). In this software there are a Im/Export menu, that easely will guide you in the process (supports server to server exporting).
Good luck, hope it helped.
Mysql-Front
phpMyAdmin
-
punkandjunk
- Forum Newbie
- Posts: 8
- Joined: Thu Jul 17, 2003 12:07 am
- Location: Jackson MI