MySQL Import and Export (.sql file) via PhpMyAdmin
Problem:
I need to Export or Import a MySQL database
Solution:
Note: PhpMyAdmin can only import and export databases up to 50 MB in size. If your database is larger you will need to use SSH instead of phpMyAdmin.Â
- Login to the MostHost cPanel
- Under the category "Databases", click on phpMyAdmin
- On the left column, select the database name you wish to import to
- Along the top of the screen click the "Import" tab
- Click browse under "File to Import" and locate the .sql file on your computer
- After you have selected the file, click GO and it will import your database.
To Export a database in phpMyAdmin:
- Login to the MostHost cPanel
- Under the category "Databases", click on phpMyAdmin
- On the left column, select the database name you wish to export to
- Along the top of the screen click the "Export" tab
- Click Select All or just the tables you need.
- Check the box saying Save as file and enter a name.
- Press Go button at bottom right.
- 51 Пользователи нашли это полезным
Связанные статьи
PHP with FastCGI
Problem:
What is FastCGI for PHP?
Solution:
FastCGI for PHP makes all your PHP applications...
Upload_Max_Filesize
Problem:
How do I change my upload_max_filesize?
Solution:
Summary
Locate the php.ini...
Cron Jobs with PHP Files
How do I run a php file using Cron jobs?
Â
From the cPanel, click the Cron Jobs icon and enter...