Importing a MySQL database - Revision history

>Samthecrazyman: Changed numbering to bullet points

2013-05-07T00:00:04Z

Changed numbering to bullet points

← Older revision		Revision as of 00:00, 7 May 2013
Line 8:		Line 8:

	== Importing your database ==		== Importing your database ==
	# If not at the console shell, open a console shell (Konsole in KDE)		* If not at the console shell, open a console shell (Konsole in KDE)
	# First we need to use the main MySQL administration program. To run this type the following:<code># mysql -u [username] -p</code>For example, to login as root, type the following:<pre># mysql -u root -p</pre>		* First we need to use the main MySQL administration program. To run this type the following:<code># mysql -u [username] -p</code>For example, to login as root, type the following:<pre># mysql -u root -p</pre>
	# Enter your password when prompted.		* Enter your password when prompted.
	# At the MySQL prompt type the following:<pre>mysql> create database [database name];</pre>For example, to create the database named 'wikidb' type:<pre>mysql> create database wikidb;</pre>		* At the MySQL prompt type the following:<pre>mysql> create database [database name];</pre>For example, to create the database named 'wikidb' type:<pre>mysql> create database wikidb;</pre>
	# If successful, you should see the following response:<pre>Query OK, 1 row affected (0.00 sec)</pre>		* If successful, you should see the following response:<pre>Query OK, 1 row affected (0.00 sec)</pre>
	# Now close MySQL by typing:<pre>mysql> exit</pre>MySQL will return<pre>Bye</pre>		* Now close MySQL by typing:<pre>mysql> exit</pre>MySQL will return<pre>Bye</pre>
	# At the console shell type the following:<pre># mysql -u [username] -p [database name] < [path to file/file.sql</pre>For example, if the username is root, the database name you just created is wikidb and the path the the dumped SQL file is the Linux root home directory, type the following:<pre># mysql -u root -p wikidb < /root/Documents/wikidb.sql</pre>		* At the console shell type the following:<pre># mysql -u [username] -p [database name] < [path to file/file.sql</pre>For example, if the username is root, the database name you just created is wikidb and the path the the dumped SQL file is the Linux root home directory, type the following:<pre># mysql -u root -p wikidb < /root/Documents/wikidb.sql</pre>
	# Once you have typed and entered the password, it may look like nothing is happening, be patient, it can take a while to import the database, especially if it is a large database or the computer is slow.		* Once you have typed and entered the password, it may look like nothing is happening, be patient, it can take a while to import the database, especially if it is a large database or the computer is slow.
	# When the import is finished you should be returned to the console shell. You may want to use the MySQL administration program to check if the data was impoted OK.		* When the import is finished you should be returned to the console shell. You may want to use the MySQL administration program to check if the data was impoted OK.
	# You database has now been imported!		* You database has now been imported!

	== Troubleshooting ==		== Troubleshooting ==

>Samthecrazyman: Small format changes

2012-03-01T03:11:29Z

Small format changes

← Older revision		Revision as of 03:11, 1 March 2012
Line 23:		Line 23:
	* '''DON'T''' forget the ; when using the MySQL administration program. If you enter a command and you get the following response:<pre>-> </pre>then you forgot the ;. To continue, type ; on it's own. Your command may then complete with a response saying it has completed. If it doesn't, type the whole command again and remember the ; !		* '''DON'T''' forget the ; when using the MySQL administration program. If you enter a command and you get the following response:<pre>-> </pre>then you forgot the ;. To continue, type ; on it's own. Your command may then complete with a response saying it has completed. If it doesn't, type the whole command again and remember the ; !

	== Related ~~articles~~ ==		== Related Articles ==
	[[Exporting a MySQL database]]
			* [[Exporting a MySQL database]]

>Samthecrazyman: Created, from Dokuwiki

2012-02-29T01:20:00Z

Created, from Dokuwiki

New page

You may need to export a MySQL database if you are moving the database to another computer (for example, you are moving you Mediawiki server). You may also need to import the database to restore a backup as databases are not stored like files and must be recovered differently. This page will guide you through the process.

== What you need to know ==
You will need the following information before you start:
* Root access to the MySQL server
* The name of the database to be imported
* Access to the dumped database file (a good place would be in your home folder)

== Importing your database ==
# If not at the console shell, open a console shell (Konsole in KDE)
# First we need to use the main MySQL administration program. To run this type the following:<code># mysql -u [username] -p</code>For example, to login as root, type the following:<pre># mysql -u root -p</pre>
# Enter your password when prompted.
# At the MySQL prompt type the following:<pre>mysql> create database [database name];</pre>For example, to create the database named 'wikidb' type:<pre>mysql> create database wikidb;</pre>
# If successful, you should see the following response:<pre>Query OK, 1 row affected (0.00 sec)</pre>
# Now close MySQL by typing:<pre>mysql> exit</pre>MySQL will return<pre>Bye</pre>
# At the console shell type the following:<pre># mysql -u [username] -p [database name] < [path to file/file.sql</pre>For example, if the username is root, the database name you just created is wikidb and the path the the dumped SQL file is the Linux root home directory, type the following:<pre># mysql -u root -p wikidb < /root/Documents/wikidb.sql</pre>
# Once you have typed and entered the password, it may look like nothing is happening, be patient, it can take a while to import the database, especially if it is a large database or the computer is slow.
# When the import is finished you should be returned to the console shell. You may want to use the MySQL administration program to check if the data was impoted OK.
# You database has now been imported!

== Troubleshooting ==

* '''DON'T''' forget the ; when using the MySQL administration program. If you enter a command and you get the following response:<pre>-> </pre>then you forgot the ;. To continue, type ; on it's own. Your command may then complete with a response saying it has completed. If it doesn't, type the whole command again and remember the ; !

== Related articles ==
[[Exporting a MySQL database]]