importing mysql data dump via command line

Recently we had to import a db dump (.sql) file of size 346MB.

Yes there are tweaks to do the same via phpmyadmin to increase post limit, timeout time, upload size etc.

However doing it command line seemed like a better option

Here is the command to import the database

mysql -u your_user -p your_db_name < sql_filename.sql

This works irrespective of the dump size.

Cheers to command line!

How can we reset the autoincrement value of primary key in a mysql table

Now while testing we keep on adding rows to tables. But once we need to put in some real data, the primary key index is no longer the initial value like an empty table.
Suppose we did 30 test entries. Even if we delete them, the next items being added start from index 31.

Here is the fix to make it start from 1 again.


We can actually set it to any value we require.

Hope it helps. Cheers!