With the migration to MySQL 5.5 there are some new features that have been introduced, where some aren’t compatible with the previous MySQL 5.1 server that was running on our servers. Default storage engine With MySQL 5.5 InnoDB has become default the storage engine instead of MyISAM storage engine. This […]
In this article, we will talk about how to backup large MySQL databases. If you simply want to export a copy of your small database and do not want to use PHPMyAdmin, you can do so using a few click method from within the backup functionality in SiteAdmin or cPanel. Let’s […]
MySQL users are crucial to your application/websites operation as it is with this very username/password creation that allows you access to view/modify and remove information from within your database. We already showed you how to create a MySQL database, now lets see how you would add or modify a user […]
From time to time it is a good idea to do a some housekeeping within your applications or websites database. This is because MySQL, like your bedroom when you were a kid – does not clean itself. If you have a large database and have a lot of traffic to […]
In this article, we will show you how to add or remove IPs/Hosts to the Remote MySQL feature. This will allow you to connect to the MySQL server from outside of the server localhost. Note: It is against our TOS to use our servers as database servers. Remote hosts should only […]
phpMyAdmin is a database management tool used for mySQL databases. It allows you to easily modify databases with a friendly user interface. Please note that when you try to access phpMyAdmin, it will open in a new window. Some popup blockers may prevent this and should be adjusted accordingly. If you are having […]
This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to use the Search feature Click the database you wish to search here Then click the Search button Enter words or values to search for in the database. There are several options you can use to refine your search. You can also […]
This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to rename database tables Click the database table you wish to rename Now click the table you wish to rename Then click the Operations button Enter a new name for the table here Then click Go That’s it! This is the […]
This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to run SQL queries on a database Click the database table you wish to run a SQL query on Click the SQL button here Then type the SQL command you want to execute Now click Go That’s it! the SQL […]
This tutorial assumes you’ve already logged in to phpMyAdmin Note: Per our Terms Of Service database sizes are limited to 2GB on our shared/reseller servers. This restriction does not occur on VPS servers. Now let’s learn how to import a table into a database 1) Click the database you wish to import your table(s) to […]
