How to Duplicate a Database using phpMyAdmin
To duplicate the database follow these steps: 1. Log into cPanel >> Databases section >> phpMyAdmin menu. For quick access, you may use cPanel Shortcuts in the Namecheap account. 2. Select the database…
-
How to remotely connect to a MySQL database located on our shared server
Due to security reasons, remote MySQL connection is disabled on our Shared Hosting servers. However, you can easily set up an SSH tunnel between your computer and our server using an SSH client with…
How to import and export a database via SSH
You can easily import/export your database using phpMyAdmin menu in cPanel. To do so, follow the instructions here. It allows processing only the databases that do not exceed 1 GB. If your database is…
How to import and export a database via phpMyAdmin (
In cPanel you can import and export databases using the phpMyAdmin menu which you can find in the Databases section. Note, that only databases of 1 GB maximum can be imported/exported in phpMyAdmin. Larger…
How to optimize website database
Database can store a tremendous amount of information â$“ all the posts, pages, comments, menus and any form of text data. The more developed site you have, the larger its database is. Along with…