Importing Data From 1 Databse To Another, On The Same Host.

[Tayuke]

Hello all

Well, I'm using the latest SQLyog Community Edition. And I have this software that requires a MYSQL, to store some of its data. Now, the softwtare is becomin better and better, with a new minor version getting released every week 🙂 AT LEAST

But, usually there is a chnage with the MySQL database. The old version MySQL database, can't work with the newer versions…and the only answer I've gottern out of my fellow freinds over at the software forums, is that the best way is copy/paste. Seriously, I don't wnat to copy/paster all the table info from 1 database, 1 table, one to another…espically when soon I'll have over 250, 500, 1000 fields….

So, I'm asking here: is there a faster way of copying data from a old table to a new table, without chnaging any of the config of the new table? I don't care how long it takes, or how advance. So long as it isn't copy/paste, and so long it works, I'm up for it…I'd need to svae as much time as possible. 😀

Thanks in Advance to anyone that can hep me. 🙂

Tayuke

[peterlaursen]

I understand you want to copy 'DATA ONLY' and not 'STRUCTURE and DATA'

You can export/dump data and import to the other.  In the export dialogue do not choose any DROP option and do not include the USE statement.  

[Tayuke]

O.k…but where's the import feature? I can't find it…I see the Import from CSV, but other than that, I see nothing. 🙁

[peterlaursen]

in the menu .. tools .. restore from SQL dump.

If there is no USE statement in the SQL you just select a database from the dropdown before importing, and it will be imported to this one.

[Tayuke]

Thank You so much 😀 I had to play around with it for a bit, before I got rid of all he error, but its worked 😀 I had to export, then reimport both the old data and new structure info.

Thanks for your help. You've svaed me alot of time…now, and in the future 😉

[Author]

Posts