CODEWITHSUNDEEP
phpmysql
Miko
Miko

Reputation: 2633

Mysql : Problem in exporting the database

I'm using php and mysql. When i try to export the database using phpMyAdmin. The database have 365 tables. But when i export i'm getting only 209 tables. The exported file size was 120mb. What's the problem exporting the file?? Either i have to change any configuration settings ??

Upvotes: 0

Views: 254

Answers (2)

Flask
Flask

Reputation: 4996

there could be multiple problems. memory limit, execution time. I guess 120mb fits exactly your memory limit ;)

try to increase this limit or try mysqldump --opt -u username -ppassword database > foobar.sql on the cli

Upvotes: 2

Andrei Stanca
Andrei Stanca

Reputation: 908

Try to export using linux console with mysqldump. A small tutorial can be found here.

Upvotes: 3

Related Questions