[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.

[memleak]

Did you figure it out or still need help?

[termit]

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