9 replies to this topic

[phpforfun]

Hey, so my old boss called me asking me if I could help him with a website, as we talked about it more, he realized I knew more than he though. To make a long story short, im making the website his company has now... better. right now its hosted by one company, sql server is ran by another company, and him and his boss know nothing about running the website.

And soon, I will setup a Centos5 LAMP server on a new server he will buy, and then recode the website, and improve it as much as possible. He said he will pay me $30 an hour, under the table, which works with me :)

First issue is...... The site that hosts his MySQL server will only export all of the data in a csv format (as far as we know), I didnt see that they would do it an a mysql dump file so I can import it.

Is there ANY way to import a CSV file into a GUI MySQL client and use it as a dump? If not we would need to either stick with this database, or retype it al in....

[John]

1) You can write a script to make an SQL dump.
2) You can install phpMyAdmin on his current server and export the SQL dump.
3) You can install phpMyAdmin on his new server and import the CVS dump to SQL.
4) You can use MySql's LOAD DATA INFILE syntax to load the CVS file as long as it is stored in comma delimited format.

[phpforfun]

I think the only one I can do is #4, ill look into it.

im not quite sure I can get access to the old server just yet, im setting up centos 5.1 tomorrow with PHP, MySQL, Apache, SSH, and whatever else I might need, while all that crap loads, ill look into that.

I use SQLYog, so maybe I can connect to the sql server? I doubt it though, I forgot what the site that had his database was called, but it seemed as if it was all controlled with the website interface, he couldnt control it.

See... as of now, I am the most experienced person on the "team", as far as web design, code, and server setups go, thus the only 2 people on it... dont know anything about sql or MySQL, so I kinda doubt they can even get the password and username.

[John]

I don't see why option 3 wouldn't work?

[phpforfun]

John said:

I don't see why option 3 wouldn't work?

you're right, sorry, I thought you can install it on the current server.. Ill see how that works. Thanks a lot John!

I just installed PHP my admin, im pretty much in love!

Edited by John, 22 April 2008 - 08:17 AM.

[Xav]

In love? I thought we had something special, phpforfun!

jk :D

[phpforfun]

sorry Xav, but phpMyAdmin does things for me that you just... cant.

[Xav]

Waah - I thought I did plenty for you... ::pee:

[phpforfun]

so I worked with him for about 7 hours today, most of it was telling him exactly what im doing.

His boss had some simple instructions.. "get the database up and running today"

however what he meant by get the database up and running is make a full PHP SQL user interface with full control.

doing a little more work on it tonight, then tomorrow morning.

[Xav]

If you get stressed, call me up - I'll give you a massage or two...