Transfer database
Moderator: General Moderators
Transfer database
-
MishaPappa
- Forum Newbie
- Posts: 7
- Joined: Wed Jul 30, 2003 7:49 am
- Location: Location... Location
Different SQL database platforms provide different means of exporting selected table(s) structure, data or both.
If a MySQL database, an easy method is to use a tool like phpMyAdmin and perform a schema dump. This will allow you to generate a text file containing the DML commands for creating the structure of the source database/table(s). This command file would then simply be executed at the target either thru direct MySQL command UI or phpMyAdmin...
YMMV based upon the source database vendor -- Have you reviewed the manual for your particular product concerning schema dumps?
If a MySQL database, an easy method is to use a tool like phpMyAdmin and perform a schema dump. This will allow you to generate a text file containing the DML commands for creating the structure of the source database/table(s). This command file would then simply be executed at the target either thru direct MySQL command UI or phpMyAdmin...
YMMV based upon the source database vendor -- Have you reviewed the manual for your particular product concerning schema dumps?
Ahh...
It is a mysql database with phpadmin on both servers.
I've always been afraid to use the dump commands as I fear it will dump all the information from the database, which is something I dont want to loose.
Thanks!
- scorphus
- Forum Regular
- Posts: 589
- Joined: Fri May 09, 2003 11:53 pm
- Location: Belo Horizonte, Brazil
- Contact:
Take a look to MySQL-Front here.
MySQL-Front has a feature to create an SQL script from the DB structure. Do it in server A then run the script on server B either using MySQL-Front or mysql console application. You can use it to copy the content too. Hope it helps!
Regards,
Scorphus.
MySQL-Front has a feature to create an SQL script from the DB structure. Do it in server A then run the script on server B either using MySQL-Front or mysql console application. You can use it to copy the content too. Hope it helps!
Regards,
Scorphus.
Thanks
Hey thanks a lot! Never knew it existed.
Mucho Thanks!
Mucho Thanks!
-
MishaPappa
- Forum Newbie
- Posts: 7
- Joined: Wed Jul 30, 2003 7:49 am
- Location: Location... Location
gib79 - I understand your trepidation in experimenting with a "dump" of the database... the verb is misleading and suggestive of bad things!
The first time I experimented with phpMyAdmin schema dumps, I made multiple full backups of everything... then realized afterwards it was unnecessary... good to err on the side of caution though.
Sometimes, you need to be fearless and try something... just remember wear protection and don't try this at home...
The first time I experimented with phpMyAdmin schema dumps, I made multiple full backups of everything... then realized afterwards it was unnecessary... good to err on the side of caution though.
Sometimes, you need to be fearless and try something... just remember wear protection and don't try this at home...
definately
hehe yeah, thats true. Things are not always as they seem.
Yep I'll be wearing plenty of protection on this venture.
Thanks!
Thanks!