PhpMyAdmin Importing Database - Revision history

DanielleM: /* How to import your MySQL database using phpMyAdmin */

2016-07-08T16:50:50Z

‎How to import your MySQL database using phpMyAdmin

Justinaes at 00:11, 25 February 2013

2013-02-25T00:11:15Z

Justinaes at 22:31, 22 October 2012

2012-10-22T22:31:56Z

Justinaes: /* How to import your MySQL database using phpMyAdmin */

2012-10-22T22:25:03Z

‎How to import your MySQL database using phpMyAdmin

Justinaes at 21:26, 22 October 2012

2012-10-22T21:26:11Z

Justinaes at 21:08, 22 October 2012

2012-10-22T21:08:46Z

Justinaes at 21:06, 22 October 2012

2012-10-22T21:06:01Z

Justinaes at 19:59, 22 October 2012

2012-10-22T19:59:09Z

Justinaes: /* Timing Out During Import */

2012-10-15T13:16:28Z

‎Timing Out During Import

Justinaes: Help and tutorial with Importing a SQL or .zip file into a MySQL database either from an internal move or changing of hosting providers.

2012-10-13T22:56:11Z

Help and tutorial with Importing a SQL or .zip file into a MySQL database either from an internal move or changing of hosting providers.

New page

__FORCETOC__

==How to import your MySQL database==

# Access Windows Control Panel (WCP)
# Click on the phpMyAdmin icon in the Database section
## If you have multiple databases/users, choose which database your want to access
# In phpMyAdmin, click on the database
# In the tab section look for select Import
# Under the File to Import: section, select Browse... to locate the SQL or .zip file on your computer
# Hit Go at the bottom of the page to being the import.

===Import Video Tutorial===
To view a video tutorial of this:
[http://hostek.com/tutorials/phpma-import.html Importing databases and tables with phpMyAdmin]

==Troubleshooting==

===#1007 - Can't create database===

#1007 - Can't create database '%dbname%'; database exists

This indicates that you have a query in your SQL file that is trying to create a database, and since it already exist, it will not 
work. Someone must edit the file and remove the CREATE DATABASE query.

===#1044 - Access denied for user===

#1044 - Access denied for user 'username'@'host' to database '%dbname%'

The issue here indicates there is a query that is attempting to create a database with the wrong username. If the database was created with a different user name than what is in the SQL file, it will need to be updated.

===Timing Out During Import===

If your database is timing out during the import process this could mean that your database is too large. You will need to contact support at [mailto:support@hostek.com support@hostek.com] Please upload your SQL or .zip database file to your root folder of your site. Windows (wwwroot) Linux (public_html). We will need to import your database for you.

[[Category:Databases-MySQL]]
[[Category:Tutorials]]

@@ Line 1: / Line 1: @@
 ==How to import your MySQL database using phpMyAdmin==
 [[File:Phpmyadmin_300.png‎]]
+===For Windows VPSs or Windows Shared Servers:===
-# Access <b>Windows Control Panel (WCP)</b> [https://wcp.hostek.com wcp.hostek.com]
+# Access your [https://wcp.hostek.com|'''Windows Control Panel (WCP.hostek.com)''']
 # You will first need to create a MySQL database by clicking on the <b>MySQL Icon</b> in the <b>Database</b> Section.
 ## NOTE: If you just created the database, you will need to refresh the page in order to complete the next step.
@@ Line 8: / Line 8: @@
 ## If you have multiple databases/users, choose which database your want to access
 # In phpMyAdmin, click on the database
-# In the tab section look for select <b>Import</b>
+# In the tab section look for and then select <b>Import</b>
 # Under the <b>File to Import:</b> section, select <b>Browse...</b> to locate the SQL or .zip file on your computer
-# Hit <b>Go</b> at the bottom of the page to being the import.
+# Hit <b>Go</b> at the bottom of the page to begin the import.
+===For Linux/cPanel VPSs or Linux/cPanel Shared Servers:===
 ===Import Video Tutorial===
-To view a video tutorial of this:
+To view a video tutorial of this process on an example Windows environment:
 [http://hostek.com/tutorials/phpma-import.html Importing databases and tables with phpMyAdmin]

← Older revision		Revision as of 00:11, 25 February 2013
Line 45:		Line 45:

	[[Category:Databases-MySQL]]		[[Category:Databases-MySQL]]
		+	[[Category:MySQL]]
	[[Category:Tutorials]]		[[Category:Tutorials]]

@@ Line 1: / Line 1: @@
 ==How to import your MySQL database using phpMyAdmin==
+[[File:Phpmyadmin_300.png‎]]
 # Access <b>Windows Control Panel (WCP)</b> [https://wcp.hostek.com wcp.hostek.com]
@@ Line 13: / Line 11: @@
 # Under the <b>File to Import:</b> section, select <b>Browse...</b> to locate the SQL or .zip file on your computer
 # Hit <b>Go</b> at the bottom of the page to being the import.
 ===Import Video Tutorial===
@@ Line 45: / Line 41: @@
 If your database is timing out during the import process this could mean that your database is too large. You will need to contact support by creating a support ticket at [https://support.hostek.com support.hostek.com] Please upload your SQL or .zip database file to your root folder of your site. Windows (wwwroot) Linux (public_html). We will need to import your database for you.
 [[Category:Databases-MySQL]]
 [[Category:Tutorials]]

@@ Line 4: / Line 4: @@
-# Access <b>Windows Control Panel (WCP)</b>
+# Access <b>Windows Control Panel (WCP)</b> [https://wcp.hostek.com wcp.hostek.com]
 # You will first need to create a MySQL database by clicking on the <b>MySQL Icon</b> in the <b>Database</b> Section.
 ## NOTE: If you just created the database, you will need to refresh the page in order to complete the next step.
@@ Line 19: / Line 19: @@
 To view a video tutorial of this:
 [http://hostek.com/tutorials/phpma-import.html Importing databases and tables with phpMyAdmin]
 ==Troubleshooting==

@@ Line 1: / Line 1: @@
-[[File:Phpmyadmin_300.png‎]]
+[[File:mysql-logo.jpg]]
 ==How to import your MySQL database using phpMyAdmin==
@@ Line 13: / Line 13: @@
 # Under the <b>File to Import:</b> section, select <b>Browse...</b> to locate the SQL or .zip file on your computer
 # Hit <b>Go</b> at the bottom of the page to being the import.
 ===Import Video Tutorial===
@@ Line 18: / Line 20: @@
 [http://hostek.com/tutorials/phpma-import.html Importing databases and tables with phpMyAdmin]
-[[File:mysql-logo.jpg]]
 ==Troubleshooting==

@@ Line 4: / Line 4: @@
 # Access <b>Windows Control Panel (WCP)</b>
 # Click on the <b>phpMyAdmin</b> icon in the <b>Database</b> section
 ## If you have multiple databases/users, choose which database your want to access
@@ Line 31: / Line 33: @@
 The issue here indicates there is a query that is attempting to <br> create a database with the wrong username. If the database was created <br> with a different user name than what is in the SQL file, it will need to be updated.
 ===Timing Out During Import===