Friday, July 24, 2015

Dumping large database into mysql sql using console

Dumping large database into mysql sql using console

Change the directory where your mysql folder is located for easyphp. Mine is as follow


C:\Program Files\EasyPHP5.3.0\mysql\bin>


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;


5 comments:

  1. Nice Website...
    Hey JOIN now fblikesbot.com and Increase Facebook Likes your profile and websites.
    Increase Facebook Likes and check your website worth worth my websites
    its may be very beneficial for you also really

    ReplyDelete
  2. Nice Information you have written here. Really Great Stuff. I keep it bookmark for our future purpose.

    We are also Web development Company in India who provide the services in Android App Development in Nagpur , SEO Company in Nagpur , Ecommerce Website Development in Nagpur. Visit Us today

    AceZed IT Solution

    ReplyDelete
  3. Fantastic experience of learning after reading your blog. I would like to share an important information that experience. Thank you

    Search Engine Optimization in Ludhiana

    ReplyDelete
  4. Very good blog post. I definitely appreciate this website. Keep it up!
    Thank You !!
    I will share your site.
    http://www.hometownledger.com/

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis