Home » Categories » Multiple Categories

How To Import and Export Databases and Reset a Root Password in MySQL

How to Import and Export Databases

Export

To Export a database, open up terminal, making sure that you are not logged into MySQL and type,
mysqldump -u [username] -p [database name] > [database name].sql
The database that you selected in the command will now be exported to your server instance.

Import

To import a database, first create a new blank database in the MySQL shell to serve as a destination for your data.
CREATE DATABASE newdatabase;
Then log out of the MySQL shell and type the following on the command line:
mysql -u [username] -p newdatabase < [database name].sql
With that, your chosen database has been imported into your destination database in MySQL.

How to Reset a Root Password

When you first install MySQL, you have to set up your root password. However, should you forget it at any point, you can still recover it.

Step One—Shut Down MySQL

In terminal, stop the MySQL process
 /etc/init.d/mysql stop

Step Two—Access MySQL Safe Mode

In safe mode, you will be able to make changes within the MySQL system with a root password alone, without the need for MySQL root password.
sudo mysqld_safe --skip-grant-tables &
Once safe mode has started up, log into MySQL and when prompted, use your standard root password.
mysql -u root mysql

Step Three—Set Up a New Password

Finally, set up the new MySQL root password by typing the command below. Replace "newpassword" with the password of your choice.
update user set password=PASSWORD("newpassword") where User='root';
Be sure to reload everything:
 FLUSH PRIVILEGES;
and you now have a new root password.
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
How To Use CakePHP to Create a Small Web Application
Viewed 1539 times since Fri, Jan 3, 2014
What is FTP and How Is It Used?
Viewed 1073 times since Fri, Dec 27, 2013
Installing and Using the Vim Text Editor on a Cloud Server
Viewed 1227 times since Fri, Dec 27, 2013
How To Use WP-CLI to Manage your WordPress Site from the Command Line
Viewed 8139 times since Sat, Jan 4, 2014
How To Install Git on Debian 7
Viewed 1583 times since Fri, Dec 27, 2013
How to Get Started With mod_pagespeed with Apache on an Ubuntu and Debian Cloud Server
Viewed 1353 times since Thu, Dec 26, 2013
How To Create a SSL Certificate on Apache for Debian 7
Viewed 1259 times since Fri, Dec 27, 2013
How To Configure and Maintain Ghost from the Command Line
Viewed 1132 times since Sun, Dec 29, 2013
How to Install Piwik on an Ubuntu 12.04 Cloud Server
Viewed 1627 times since Sat, Jan 4, 2014
How To Copy Files With Rsync Over SSH
Viewed 1336 times since Fri, Dec 27, 2013