Php – No data was received to import

importMySQLPHPphpmyadmin

I want to import database in phpmyadmin but i got error like this… "No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration." my file size is 558kb, on live server

Best Answer

If your database size is greater than 2MB then such problem will occur, goto php.ini, then find upload_max_filesize = 2M now replace 2M to upload_max_filesize = 10M now no problem unless your database size is less than 10MB. You can set value as per your requirement.

Related Solutions

Mysql – How to restore a dump file from thesqldump

If the database you want to restore doesn't already exist, you need to create it first.

On the command-line, if you're in the same directory that contains the dumped file, use these commands (with appropriate substitutions):

C:\> mysql -u root -p

mysql> create database mydb;
mysql> use mydb;
mysql> source db_backup.dump;

Mysql – Should I use the datetime or timestamp data type in MySQL

Timestamps in MySQL are generally used to track changes to records, and are often updated every time the record is changed. If you want to store a specific value you should use a datetime field.

If you meant that you want to decide between using a UNIX timestamp or a native MySQL datetime field, go with the native format. You can do calculations within MySQL that way ("SELECT DATE_ADD(my_datetime, INTERVAL 1 DAY)") and it is simple to change the format of the value to a UNIX timestamp ("SELECT UNIX_TIMESTAMP(my_datetime)") when you query the record if you want to operate on it with PHP.

Best Answer

Related Solutions

Mysql – How to restore a dump file from thesqldump

Mysql – Should I use the datetime or timestamp data type in MySQL

Related Topic