[Desec0x]

Anybody knows how one can convert a big SQL data to Excel? Is it possible or too big?

I have a 120MB, 606MB & 0.96GB that I want to convert to excel, but all the applications I have used kept freezing. Anybody knows of any solution that might work?

[zinzeur]

did u tried this
mysqldump -u <username> -p<password> -T <output_directory> --fields-terminated-by ',' --fields-enclosed-by '"' --fields-escaped-by '\' --no-create-info <database_name>
after connecting to ur mysql server
if u have only the SQL file u can load into mysql server first

[Darth_Vader]

did u tried this
mysqldump -u <username> -p<password> -T <output_directory> --fields-terminated-by ',' --fields-enclosed-by '"' --fields-escaped-by '\' --no-create-info <database_name>
after connecting to ur mysql server
if u have only the SQL file u can load into mysql server first

Cool, thanks for that. Never really needed to do this myself, but will save this somewhere for the future.

This forum account is currently banned. Ban Length: Permanent (N/A Remaining)
Ban Reason: Leeching.

[memleak]

Did you figure it out or still need help?

[termit]

Excel limit is 1 million rows, everything comes down to this