by dabempire | Feb 22, 2011 | DNS and Domains, Knowledgebase
All administration of your MySQL databases and users can be done through our convenient web based control panel interface. This program is provided to all of our hosting customers.
by dabempire | Feb 22, 2011 | DNS and Domains, Knowledgebase
There are two main ways to back up or restore a MySQL database on our servers: via SSH or the phpMyAdmin interface. If you need SSH Telnet access, just send us a ticket with your request to be enabled for it. To access the phpMyAdmin interface, click on the “phpMyAdmin” on your control panel. How create a backup a MySQL database using SSH: Log into your account on our server and issue the following command: /usr/bin/mysqldump DATABASENAME -u USER -pPASSWORD > /home/user/file.sql Enter your actual username and password where we have indicated user and password. This will create a file called “file.sql” that contains your entire database. How to restore a database using SSH : Log into your account on our server and issue the following command: mysql DATABASENAME -u USER -pPASSWORD < /home/user/file.dump How to create a backup MySQL database using phpMyAdmin: Click on your database name shown on the upper left. Go to the section called “View dump (schema) of database” and choose options for backing up structure only, structure and data, or adding drop tables. To view what your backup file will look like, click on the “Go” button. When you’re ready to send your back up to a file, check the send box and click “Go”, then follow the prompts for how to name the file and where to send it. How to restore a MySQL database using phpMyAdmin: Click on your database name shown on the upper left. Locate your back up file for the database that you want to restore. Open it and copy the entire contents. Paste into the field called “Run...
by dabempire | Feb 22, 2011 | DNS and Domains, Knowledgebase
Yes! it is possible. For this you have to allow remote access from your control panel, by adding your IP to the access hosts in mysql screen there. If you do not have a fix IP at your end you can use % as wild card and allow remote access from anywhere. Then for remote connection you have to use the server IP or your domain IP or domain name instead of localhost in your script/program. For example, to connect remotely via mysql command line utility: mysql -h x.x.x.x -u USERNAME -p DATABASE (where x.x.x.x is your server ip, USERNAME is the db user, and DATABASE is the database name) NOTE: Whenever an IP/Host is added or removed from the Access Host field, the privileges need to be reassigned to the database user on that database otherwise it will produce Access Denied...
by dabempire | Feb 22, 2011 | DNS and Domains, Knowledgebase
Please login to your control panel and follow these steps to create the database, user and its password: Once you login into your control panel, please click on “MySQL Databases” under “Database” section and then a) Use the option “Create MySQL database” to create the database, say “dbname”. The database name will have your username as its prefix username_ i.e. username_dbname b) Create a database user from the same interface and note down the username and password, say username_user c) Grant ALL privileges to this user on the database created using the option “Grant permissions on a MySQL database to a MySQL user” Now you have following ready: Database: username_dbname DB user: username_user DB user passwd: XXXXXX (this is what you setup in step b) host: localhost Now you can use these values in your php or perl script to connect it to the database. To browse your database, you can click on phpMyAdmin in your control...
by dabempire | Feb 22, 2011 | DNS and Domains, Knowledgebase
MySQL is a very robust database server. It is often used to deliver dynamic content to sites such as forums. The languages most often used to interface with the database server are Perl and PHP, however, C, C++, and Python among others may also be used. The official MySQL Web site may be found at:...
