I have two niche websites that I made in the a very similar niche.  I put almost no effort into one and spent a great deal of time on the other.  Wouldn’t you know it?  The one with no work is making almost $200 a month.  Not a fortune but I have not done a minute of work on it since I built it about six months ago.

The sites had an identical structure.  so I wanted to get the data from the larger one, that I thought would make money, and import it into the one that actually does make money.  After some research, here is how I did it.

Go to your phpMyAdmin in database A.

In phpMyAdmin open the table, click “SQL”, change the SQL query to SELECT all fields without the field that gets you the duplicate error (for example ID that has auto_increment).

For example:

Normal query: SELECT id, name, address, city FROM table

You do: SELECT name, address, city FROM table

Click ‘Go’. It will show you the results. Now just click ‘Export’ (not the one in the header but in the ‘Query results operations’ area). It will forward you to the export page. Just press GO and your done.

Now you can import it into your database ‘B’.