Many of you probably know that you can not upload larger databases or tables using the standard PHPMyAdmin interface. PHPMyAdmin will normally crash when you try to import a table or database that exceeds 4,000kb. That is why I am posting these instructions on how to import larger databases or tables into MySQL.
First get the MySQL command prompt with:
mysql
Then from the mysql prompt type
use database_name
In the above command, replace database_name with the name of the database you are trying to import into. If you have not created the database yet, you can do that easily from PHPMyAdmin. Next type:
source /var/www/html/file.sql
In the above command replace /var/www/html/file.sql with the path and filename of the .sql file you are importing.
eg: C:\file.sql
0 comments:
Post a Comment