| How do I import a database using phpMyAdmin? |
To import your MySQL database, you can use phpMyAdmin which is available in your control panel. The steps to import your database are below.
1. Click on the icon labeled MySQL Databases in your control panel.
2. At the bottom of the screen in MySQL Databases you will see an option for PhpMyAdmin, click on it
3. Once in PhpMyAdmin you will see on the left side a drop down of your databases, select the database you would like to import to.
4. This will create some tabs at the top of the screen, click on SQL.
5. After clicking on SQL you will see a Text Box area and a file upload option.
6. Click browse on the file upload option and find your .sql file
7. After you have selected the file click GO and it will import your database. It may take a while to complete importing especially if your database is large.
If there are errors feel free to contact us. |
| I recently imported several databases via phpMyAdmin. I had to first manually create each database that I wished to import using the database manager. I also had to take out the sql statements for creating each database, from the import file. Once the databases were created, I had no problems importing the tables and data as specified above. |
how to upload file using phpmyadmin if the file have over size?
phpmyadmin max upload file Max: 8,192 KiB, how to upload file if have over size than phpmyadmin have it?
thanks and sorry my english is bad, hope you know about my problem
salam
bagus |
i cant upload !!
it says these errors
Error
SQL query:
--
-- Database: `nicho`
--
-- --------------------------------------------------------
--
-- Table structure for table `inquiry`
--
CREATE TABLE IF NOT EXISTS `inquiry` (
`name` text NOT NULL ,
`email` text NOT NULL ,
`subject` text NOT NULL ,
`inquiry` text NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET = latin1;
MySQL said: Documentation
#1046 - No database selected |
i cant upload !!
it says these errors
Error
SQL query:
--
-- Database: `nicho`
--
-- --------------------------------------------------------
--
-- Table structure for table `inquiry`
--
CREATE TABLE IF NOT EXISTS `inquiry` (
`name` text NOT NULL ,
`email` text NOT NULL ,
`subject` text NOT NULL ,
`inquiry` text NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET = latin1;
MySQL said: Documentation
#1046 - No database selected |
All times are GMT. The time now is 10:23 AM.
