Technical help with SQL File

Saj · Jun 16, 2008

From my website i have managed to download our product details in the form of a mysql file. We have tried to follow steps & procedures to install software to open the file.

But as i dont have a technical background we cant reach my objective of getting to the information stored in the mysql file. (All i want to achieve is transfer all the infomation from mysql file into MS Access / MS Excel format).

Thank you for your help
designersofas4u.co.uk

dave_n · Jun 16, 2008

download them as a csv then simply import into access/excel

select * into outfile '/tmp/zips.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
from products, image_maps_to_products
where product_id = product_id;

Saj · Jun 16, 2008

Where can i get hold of the mysql program?

dave_n · Jun 16, 2008

its free off the web

ServWise · Jun 16, 2008

Exporting as SQL doesn't sound like a typical data export for an application more of a Backup function for re-import.

Did you export as a SQL dump from something like phpMyAdmin?

The problem is that it's not easy to get from a SQL dump to access directly as there is no database just a bunch of SQL commands that create a DB/Tables/Data in mySQL. So it is far easier to export direct from mySQL to a CSV as it simply loops through your records and creates the correct data in a csv text file.

If you did the dump using phpMyAdmin then there should be an option to export to csv/excel instead of a SQL dump, Better to try that than try to find a piece of software to convert.

essexboyracer · Jun 16, 2008

What do you want to do with the data exactly?

Once imported into excel, is there a manipulation you plan to do in excel that you cant do in MySQL? You could...

Get Access to connect to your remote web hosted MySQL database via ODBC, you could then edit the data live within the comfortable bubble of Access
Depending on your version of phpMyAdmin, if that is the tool you used, export directly to excel, the easiest option. Its on the EXPORT tab
As you have done, download a copy of the live MySQL DB then edit it on a staging server (.en.wampserver.com) that you have, installed to localhost.
Export the data from phpMyAdmin as CSV then import into excel.
If no phpMyAdmin, get someone to write a script to export the data in a format easily to import into excel.

----------------------------
Tring Web Design

Search

Search

Technical help with SQL File

Saj

dave_n

Saj

dave_n

ServWise

essexboyracer

Similar threads

Latest Articles