Dumping large database into mysql sql using console
Change the directory where your mysql folder is located for easyphp. Mine is as follow
Type the following command, i am accessing via root.
C:\Program Files\EasyPHP5.3.0\mysql\bin>mysql -p -u root;
Enter the password:
Drop the current database.
mysql > drop database [database name] ;
mysql > show databases;
mysql > create database [database name] ;
mysql > use [database name] ;
Dump data into the database
mysql> source freepres_freeprdb.sql ;
mysql> show tables;
Check the total records, to see the latest record.
mysql > select count(*) as total_records from articles;