CODEWITHSUNDEEP
mysqlsizelimit
Rima Touya
Rima Touya

Reputation: 31

Import database even if it exceeds the limit size

I've noticed that MySQL accepts only 2,048kb size of database but mine is 3.45mb. Does anyone know how to import the database? I'm only using phpmyadmin.

Upvotes: 2

Views: 19959

Answers (2)

Kushal Jayswal
Kushal Jayswal

Reputation: 933

Here are simple steps:

  1. Open .sql file
  2. Select All (ctrl + A)
  3. Copy All
  4. Goto PhpMyAdmin
  5. Select DATABASE
  6. Open SQL tab and PASTE

Now wait for sometime.....

Upvotes: 5

Mudassir Hasan
Mudassir Hasan

Reputation: 28751

Use command line interface to do the import . I don't think there is such small limit for database size in MySQL . From MySQL documentation SIZE LIMITS

The limit may be if you are using phpmyadmin which may limit file upload size according to settings specified in php.ini file

Syntax

   $ mysql -u {DB-USER-NAME} -p {DB-NAME} < {db.file.sql}

If you want do import using phpmyadmin change settings in php.ini file

post_max_size = 10M 
upload_max_filesize = 10M

Upvotes: 6

Related Questions