That can cause errors saying the (empty) database already exists:ĮRROR 1007 (HY000): Can't create database 'database_name' database exists You might have problems following the instructions above if your dump file came from another system that added a line like this: What if my “dump” file already contains a CREATE DATABASE line? If you need our assistance more than once, a fee would be involved as described on our FileFix page.īy the way, you can ensure the database is empty by first using our control panel to delete and recreate it. We’ll be glad to import it for you (this may take up to one business day), and there’s no charge as long as you only need this done once. Let us know the name of the file and the name of the empty MySQL database you want to import it into. If you need assistance with the second (shell) part of this, please contact us after you’ve uploaded the dump file using FTP. This is the password you chose when you created the MySQL database, not your master account password. Mysql -u database_name -p database_name < filename.dump When connected, type the following command, replacing “database_name” with the actual name of the MySQL database you want to use and “filename.dump” with the name of the file you uploaded: Then you’d connect to the shell using SSH. To use the MySQL command line, you’d first upload the dump file to your website using an FTP program, etc. zip compression of dump files because we've had reports of it causing problems. Make sure the dump file you’re importing is uncompressed. (If you see a “No database selected” error, it’s probably because you forgot to click the database name in step 2.) Click the browse button under “File to Import”, then select the database file from your computer.Click the database name on the left-hand side of the page.Login to the new database using phpMyAdmin.You’ll first need to create the new, empty database on our servers using the account control panel. What if I have a CSV file instead of a MySQL “dump” file?.What if my “dump” file already contains a CREATE DATABASE line?.If it’s larger, or if you get “timeout” errors, you’ll probably need to use the MySQL command line. If the file is smaller than 100 MB (uncompressed), the phpMyAdmin Web pages we provide can often be used. If you have a backup (“dump”) file of a MySQL database (made either from our MySQL backup system or on another server), you can import that SQL dump file into our system.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |