Which version of MySQL is available?

On our old shared/sdx/reseller servers, we have setup 4.1.x which is still the most popular version and is supported by most web applications. Unfortunately we can not upgrade this to 5.x as this will break a lot of customer’s websites. On the other hand our new shared/sdx/reseller servers are setup with MySQL 5.0.x. If you need to use newer version i.e. 5.x, you can ask JaguarPC Support to move your account to the newer server but make sure the queries in your scripts/applications are compatible with 5.x...

Why do I get error message: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ on shell?

If you get this error message when trying to use mysql command line utility from shell: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ It means you need to access the mysql using -h 127.0.0.1 e.g. mysql -h 127.0.0.1 -u yourdbuser -p yourdatabase If you get this error message from a web script, please check with support for the status of the mysql...

Can I import csv files using Load Data Infile?

This feature is not supported by cpanel but you can ask support to add File_priv to your db user that needs to import csv files. After that you can use this format on mysql command line utility via ssh: LOAD DATA LOCAL INFILE ‘upload.txt’ INTO TABLE mydatabase.mytable FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY...

How can I backup and restore my MySQL databases?

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...

Can I connect remotely to MySQL database?

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...