开发者

Splitting a SQL insert from PHPmyAdmin to Adminer

I am trying to move my database to another server.

My Adminer has a 2MB SQL max dump (upload) limit.

I currently have one table that is开发者_如何学Go about 10MB big.

I was wondering what approaches I can take to split this 10MB table (or modify the dump file) in order to import it via Adminer.


There are following options:

  • Upload the file by FTP as adminer.sql (or adminer.sql.gz) and then run it from server.
  • Gzip or Bzip2 the file - maybe it can squeeze in 2 MB.
  • Increase the PHP limit - upload_max_filesize and post_max_size.
  • Export the table by parts - limit the result set and export it from select.


Try this : Adminer: to increase limit for import

/etc/php/5.6/apache2$ *sudo vim php.ini*

upload_max_filesize = 200M // 2M originally

sudo service apache2 restart


If your database.sql.gz file is on server or anywhere else, you can import it using the following method.

$ zcat import_file.sql.gz | mysql -uroot -p database_name

It will ask you for your SQL password, just entered it, and then you're done. If database_name flash the error then just create manually database_name in your "adminer" then import. It will work 100% sure.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜