Dynadot Aftermarket: discover domain gems worth investing in. Visit our aftermarket.

Importing MySQL

SpaceshipSpaceship
SpaceshipSpaceship
Namecheap AuctionsNamecheap Auctions
Watch

Dan

Buy my domains.VIP Member
Impact
108
The old script I am trying to export has over 100 rows of information. I don't want to manually go through and add each one. The problem is, the database isn't set up the same way, so an easy export, import won't work. I'm wondering what the best way possible to do it is.

The only way I can think of is to write a PHP script that explodes it by new line, then by ',' (how each value is seperated). Then, I can put each array piece back together and implode it into the new way.

Any suggestions?
 
0
Close
The views expressed on this page by users and staff are their own, not those of NamePros.
GoDaddyGoDaddy
I'd write a script that loops through the database and selects everything that's important and then writes an SQL statement for the proper way to insert it into the new database. Loop for every line and then whatever it prints out should be all that's needed for the new import.
 
0
Close
Well, I got it. It was pretty easy. :x

I exported the sql I wanted, exploded it by commas, put each thing I wanted into an easy to remember variable and wrote the MySQL query.
 
0
Close
DomainEasy: white label portfolios are live. Enable yours.

We're social

Escrow.com
Spaceship
Domain Recover
CryptoExchange.com

NamePros updates

A browser tab with a favicon next to the page title
Search members
You can now search for members by name, company, location and more. Open the search at the top of any page and choose Members. You will...
AIVikings
Catchy
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back