Need some help with this....

Is there anyway to convert MYSQL data file .sql to MS Excel from my PC?

I understand that it is possible to upload as .sql file to phpmyadmin and extract as Excel CSV format however, one of my client passed me a 60mb MYSQL data file which is a little huge.

I gzipped the file and it changed to 3+mb however when I try to upload to phpmyadmin, it just will not enter into the data structure.

I also tried bzip however it's the same.

Is there any direct convertor for MYSQL to Excel?

Thanks in advance!

Try http://www.sharewareriver.com/product.php?id=1477

Excel worksheet can have only 64K rows. Are you sure your tables under this limit? If no, you will need to cut tables for some sheets.

You can try connect to MySQL via ODBC (MS Excel support it). Sure, your traffic will be huge, but it is really comfortable.

Originally posted by c3uc3
Need some help with this....

Is there anyway to convert MYSQL data file .sql to MS Excel from my PC?

I understand that it is possible to upload as .sql file to phpmyadmin and extract as Excel CSV format however, one of my client passed me a 60mb MYSQL data file which is a little huge.

I gzipped the file and it changed to 3+mb however when I try to upload to phpmyadmin, it just will not enter into the data structure.

I also tried bzip however it's the same.

Is there any direct convertor for MYSQL to Excel?

Thanks in advance!

In the php.ini file there is a limit set to how big your uploads are. Archiving and zipping them up will not make them readable by the SQL server. You can set in .htaccess and change the upload limit. But what you might want to do is look into tools that will split an sql file into smaller files so you can upload it.

There are also tools and some php functions where you can convert sql data to excel files. But you need to look that up or someone else can help you.

I always got timeout in PHPMYADMIN =(

www.dbtools.com.br

Direct export to Excel and it's free :)

Thanks Paulo!

It's funny how this is.

The gz file is 3mb

I uploaded the .gz file of the SQL file onto my server.
unzip it. (Unzip/untar = 60mb)

use mysqldump -uusername -ppassword databasename < database.sql

MYSQL just reply with,
-- MySQL dump 9.11
--
-- Host: localhost Database: databasename
-- -------------------------------------------------------------
-- Server version 4.0.20-standard


Then nothing else happens, goes back to "command prompt".

I check the mysql database and there is no tables at all.

Any idea what is happening?