If you have bigger database backup and you want to import SQL file into your database it will be easier to use the Terminal. Simply follow these steps:
1) Go to sql file backup directory (e.x. Desktop)
2) In terminal:
metodiew@metodiew:~/Desktop$ mysql -u <database username> -p <user password> <database name> < <your file>.sql
Note: you can skip <database name> if you have one SQL backup file.
metodiew@metodiew:~/Desktop$ mysql -u <database username> -p <user password> < <your sql backup file>.sql
Of course you can using phpMyAdmin Import option, but you might have problems if your file is bigger and you don’t have made any changes to your server configuration. Also it will be faster and easier for person who is comfortable with working Linux terminal to type two-line command and to wait for uploading the file. If the file is larger, you can always go for a coffee š
Keep in mind this post it mostly for me, because Iām a lazy person when it comes to remembering commands, so it will be easier for me to find the snipped and to use them in the future š
Stanko Metodiev is a WordPress veteran and the CTO of DevriX. For the past 12 years Stanko has been developing complex SaaS platforms, multisite solutions, migrating various systems to WordPress, managing a team of developers and leading a few key international projects in the company. In the past years, Stanko is the lead organizer of the WordPress Sofia User Group (WPBGUG) and has been a part of the organization of WordCamp Sofia and WordCamp Bulgaria. In his portfolio, you can find free themes and plugins on WordPress.org, and badges of his membership in the WordPress support, polyglots, theme reviews teams. Stanko is a fan of Real Madrid and often watches football games in shisha bars with friends and with his family at home. Also an avid fan of Counter-Strike and an active member of the remote work culture worldwide.
Leave a Reply