MySQL to MySQL

[rjonk]

I want to import some data from one MySQL-database to another MySQL-db on the same server. How can I realize it?

Thanks, rjonk

[phpjuggler]

Hi,
the first question is if you want to import only some tables, or some records.
if you got php on your server, simply install
phpMyAdmin and do it with this nice little app.
If you don't know how to work with phpMyAdmin, no problem at all. I show you how.

Greetings
juggler

[[deleted]]

phpMyAdmin is notoriously bad at import/export jobs.

Instead, read the MySQL manual about mysqldump.

[phpjuggler]

Hi,
yes i think vincent is right.
So, if you have any questions about mysqldump...

Greetings
ilija

[rjonk]

OK, I want to import some records, butnot the whole records, just some fields.
Is that possible?
I do not know how to do it with mysqldump.
I hope you can give me some hints.

Thanks
rjonk

[dr3amscap3]

Essentially you want to do something very similar to this on the server you want to EXPORT data from:

mysqldump -u user -ppass -h host databasename > export.mysql

You can remove -u, -p, -h depending on where your server is and your mysql.cnf

On the server you want to IMPORT the data on you do this:

mysqldump -u user -ppass -h host < export.mysql

You can get fancy, and do --add-drop-table, and that will drop tables if you already have the structure before adding the new ones.

Look at the mysql documentation online (www.mysql.com) it's good.

Jeff

[rjonk]

I do not want to import all tables. I only want to import some columns of some tables of the source db into the target db (perhaps into existing tables without deleting existing records).
Can I do this with mysqldump?
(export and import databases are on the same MySQL server)

rjonk

[Anon]

you can use the mysql client to do this...

somethinng like this if you're using *unix

insert() {
mysql db2 -uuserid -ppassword -e "INSERT INTO table VALUES('$1','$2','$3')"
}

mysql db1 -e 'select name, password, email from users' | grep -v "|" | grep -v "name" | awk '{print $1 "\t" $2 "\t" $3}' | while read mydata; do
insert $mydata

done

[Anon]

My previous post is ran as a shell script

#!/bin/sh

then the above code.example

If you get it working and need to perform the operation often. cron job the script

if you are wanting to UPDATE a table change the insert function to read something like..

insert() {
mysql db2 -uuserid -ppassword -e 'LOCK TABLES table WRITE'

mysql db2 -uuserid -ppassword -e "UPDATE table SET name = '$1' , password = '$2', email = '$3' WHERE id = something

mysql db2 -uuserid -ppassword -e 'UNLOCK TABLES'

}