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!
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.
ALTER TABLE tablename AUTO_INCREMENT=0
We can actually set it to any value we require.
Hope it helps. Cheers!