Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

HTML Forum


You are currently viewing our HTML Forum as a guest. Please register to participate.
Login



Post a Project »

Find a Professional HTML Freelancer!

Find a Freelancer to help you with your HTML projects

FREE Outsourcing eBook!

Reply
How to convert SQL table for different script
Old 07-25-2007, 05:59 AM How to convert SQL table for different script
Extreme Talker

Posts: 157
Trades: 5
Hi,

I want to buy some database (which come with a sql table dump file).
But it is not match with my script sql format.

Please help to suggest some tools that I can import the sql table, and do some change to the format,

Many thanks
__________________

Please login or register to view this content. Registration is FREE
..........
Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE
......
Please login or register to view this content. Registration is FREE
danieloffice is offline
Reply With Quote
View Public Profile Visit danieloffice's homepage!
 
 
Register now for full access!
Old 07-25-2007, 09:14 AM Re: How to convert SQL table for different script
Novice Talker

Posts: 8
Trades: 0
I would do it the following way.
1. Import SQL dump file to empty database.
2. Write a script (I would write it in php, but it does not matter) which reads each record, converts it to required format, and saves it to database of your format.
Bustik is offline
Reply With Quote
View Public Profile
 
Old 07-25-2007, 09:34 AM Re: How to convert SQL table for different script
tripy's Avatar
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
As Bustik said.
I believe it's the most efficient way.

I've used this technique on big tables (between 300Mo and 1Go) and it worked quite well.
__________________
Only a biker knows why a dog sticks his head out the window.
tripy is offline
Reply With Quote
View Public Profile Visit tripy's homepage!
 
Reply     « Reply to How to convert SQL table for different script
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.33760 seconds with 12 queries