Absolute Moments

Today i was busy with CodeCharge with php+mysql. All the while, I knew that database is my weakness, and I only know how to do basic query, insert, update, delete, joins, etc

I installed CodeCharge, php, mysql and some other software again (I can’t have these software inside Dxll laptop). While I googling for sample databse, I found “Sakila” sample database is available at http://downloads.mysql.com/docs/sakila-db.zip which is the most famous sample database for mysql. The archive contains two files: sakila-schema.sql and sakila-data.sql.

I tried import by using phpMyAdmin but i got timeout for sakila-data.sql due to large data need to process. So I google it how to use command prompt to dump the sql.

Just to share if you also don't know how to:

First I dump in sakila-schema.sql for schema creation.

   1: C:\>mysql -u root -p sakila < sakila-schema.sql

   2: Enter password: ********

   1: C:\>mysql -u root -p sakila < sakila-data.sql

   2: Enter password: ********

Your IP Address is:
38.107.191.92