mysql import and export data from command Line

import data

mysql -u root -p firenze1_wp < /var/www/firenze1_wp.sql

export data

mysqldump -u [username] -p [database name] > [database name].sql

Import file size limit in PHPMyAdmin

162 down vote

With apache2 and php5 installed you need to make three changes in the php.ini file. First open the file for editing, e.g.: sudo gedit /etc/php5/apache2/php.ini Next, search for the post_max_size entry, and enter a larger number than the size of your database (15M in this case), for example: post_max_size = 25M Next edit the entry for memory_limit and give it a larger value than the one given to post_max_size. Then ensure the value of upload_max_filesize is smaller than post_max_size. The order from biggest to smallest should be: memory_limit post_max_size upload_max_filesize After saving the file, restart apache (e.g. sudo /etc/init.d/apache2 restart) and you are set. Don't forget to Restart Apache Services for changes to be applied.