Author's posts
How to dump a database using SSH?
If you have SSH enabled, you can export a database to your hosting account, using the following command, replacing the name, username, host and password with your database ones: mysqldump DB_NAME -uDB_NAME -hMYSQL_HOST -pPASSWORD > /home/www/path-to/file.sql
How to export a database?
To create a export your database, access the phpMyAdmin tool via the phpMyAdmin icon right next to your database name. Once you login, select the database from the left frame and click on the Export button that will appear at the top of the central frame. You can select to export all tables of the database …
How to import file into a database using SSH?
To import date using this method, you will have to upload the SQL file in your account first and then login via SSH to this account. Once this is done, use the following command, replacing the name, username, host and password with your database ones: mysql DB_NAME -uDB_NAME -hMYSQL_HOST -pPASSWORD < /home/www/path-to/file.sql
How to import a database file in existing database?
To import data into your database, access the phpMyAdmin tool via the phpMyAdmin icon right next to your database name. Once you login, select the database from the left frame and click on the Import button that will appear at the top of the central frame. At the import screen, browse the file that you wish …
How to create a new database?
MySQL database is used to store user information in a structured way. MySQL databases are used with most PHP applications. To add new database to your hosting account, click on the “Create New Database” action button. This will open a new pop-up window, where you will have to fill in the database username and desired …