Welcome to WebmasterWorld Guest from 54.167.65.247

Forum Moderators: open

Message Too Old, No Replies

Excel to Mysql conversion.

Trying to move from CMS to my own system.

     
9:35 pm on Jan 24, 2006 (gmt 0)

New User

10+ Year Member

joined:May 23, 2005
posts:2
votes: 0


Hello.

I'm attempting to convert from a lousy CMS to a custom system more suited to my needs.

I was wondering if there were an easy (free) way to convert my data using MS Excel? I've tried exporting my MYSQL data to excel using CSV, adding and renaming the new tables that I need, and importing it into the new database on my test site.

When I've done this, I've gotten errors about line deliminated by ___ .

Anyone able to help?
Thank you.

9:26 pm on Feb 9, 2006 (gmt 0)

Administrator

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 24, 2001
posts:15755
votes: 0


data conversion is a very tedious task

are you going from mysql to mysql?

You don't necessarily need to use excel/csv as the go between.

if you could create all of your old tables in your knew database you could use some scripting to convert it as well.

10:16 pm on Feb 9, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Jan 17, 2003
posts:1947
votes: 0


I've done this a lot. Should be easy. Why not try exporting, importing, and THEN deleting whatever you don't want?
4:30 am on Feb 20, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:Aug 30, 2002
posts:2511
votes: 44


What database are you converting/importing from? Do you have the schema for the tables in the old db?

If it is MySQL to MySQL, then it is a lot easier.

Regards...jmcc

4:36 am on Feb 20, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Feb 19, 2006
posts:43
votes: 0


You should give Navicat MySql a spin.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members