Moving Data from 1 MySQL DB to another

[RichinStPete]

Hello,

I have recently been given the task to merge some asset information from an access 2000 DB to a MySQL DB. I have exported it out of Access into MySQL with MySQLFront and created a Test DB in MySQL. My problem it I need to be able to put information out of this MySQL DB and put it into another MySQL DB. I have information like, user names, asset tag numbers and so on that I need to put in the correct location. ie In one database I have a asset tage number, in the other I have that same take number but also things like Org number description of device and so on. I need the information for that perticular asset tag taken out and move into the correct location in the other DB. I am very new to MySQL and I am not sure how easy or hard this is, I just know I do not know how to do it. Can any of you MySql Masters help me out?

Thanks!

 

[Bastien]

not very hard, you can write a script to pull from one and place in another or simply download the required columns in to a text file and upload into the new db...i am not sure if mysqlfront supports this (probably does) I know phpmyadmin does support this and is very easy to use...

Bastien

cat, the other other white meat

 

[RichinStPete]

Thanks for the information Bastien. I looked into the PHPMyAdmin and i have never seen such a product that is so hard to install and configure. Not to mention its dependant on a webserver and lack of none expert install instructions makes it difficult to use. Do you know of any other products tht will do what I need?

Thanks!

 

[Bastien]

why not export a dataset from the orignal access file...if the data has not changed you can create a csv file and import that with mysql_load

Bastien

cat, the other other white meat

 

[QatQat]

Or if you export a text file with separator then you can use mysqlimport or LOAD DATA INFILE

http://www.mysql.com/doc/en/mysqlimport.html

Bye

Qatqat

Life is what happens when you are making other plans.

 

[spookie]

u can also make use of mysqldump.

http://www.mysql.com/doc/en/mysqldump.html

--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

 

[sleipnir214]

If the two installations of MySQL are the same version, why not just use your filesystem's copy command?

On the new database server, create a database with the same name as the database on the old server. Shut down the new database server.

Copy the files from the database directory of the old database server to the new database server.

Make sure the copied files are owned by the user as which MySQL runs, and that MySQL has read an write permission to all the files.

Restart the new database server.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!