CODEWITHSUNDEEP
phpmysqlapache
jollins
jollins

Reputation: 48

Exporting mysql database to csv through php stops after 4kb

I am using a script which is designed to pull tables out of a database and format them to csv and save to you machine.

It works fine and all but as soon as the file hits 4kb it stops and saves.

Obviously the table is larger than 4kb so it gets cut off mid sentence.

I'm thinking a memory allocation issue? any ideas as to what might cause this?

running apache

Upvotes: 1

Views: 270

Answers (1)

arutaku
arutaku

Reputation: 6107

PHPMyAdmin and this stuff have many problems when you try tu export your DB (buffer limitations...).

To export your MySQL data you could try mysqldump: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

This way:

mysqldump -u [user] -p[user_password] [database_name] > backup.sql

PS: be careful because -p paramater goes without a white space.

Upvotes: 2

Related Questions