Docs Category: MySQL
MySQL
9 Docs
How do I export a .sql file via the command-line
Last Updated: May 5, 2026If you’ve set up SSH access for a package, then you can use one of two methods to export a MySQL database via the CLI. MySQL CLI To export a SQL file via the command line, you can use the mysql command. Here’s how. mysqldump -h hostname -u username -p database_name > file.sql Replace hostname with your database server...
How do I download or back up my MySQL Database?
Last Updated: May 5, 2026There are various ways to export your MySQL databases for safekeeping or transfer. The first method allows you to back up multiple databases via your WebHostsOnline Web-Solutions control panel and the second on a ‘per database’ basis via phpMyAdmin. Backup/Restore The control panel provides an easy way to download all databases associated with your hosting...
How do I import a .sql file via the command-line?
Last Updated: May 5, 2026If you’ve set up SSH access for a package then you can run the following command-line instructions to import a MySQL database: mysql -h hostname -u username -p username < databasefile.sql The above command connects to your database with the -h (hostname) -u (username) -p (database name in this case) then the unzipped file <...
Can I view my FTP, email address, or database passwords?
Last Updated: May 5, 2026We encrypt all FTP, email and database passwords so they are not visible as plain text inside your control panel. The exception is the very first FTP account: this password is visible on the right hand side when you manage your hosting. You’re able to change all passwords and changes are usually processed immediately. Please...
How do I create a MySQL database?
Last Updated: May 5, 2026You can create MySQL databases in seconds directly from your WebHostsOnline Web-Solutions control panel. This option is unavailable for packages hosted on our WordPress platform due to its WP-optimised nature. If you need to create a MySQL database, you’ll need to move the website to our Linux platform.To create new MySQL databases: 1. Log in to my.webhostsonline.co.uk and select Manage...
What’s the maximum MySQL database size allowed?
Last Updated: May 5, 2026At WebHostsOnline Web-Solutions, each MySQL database you create can store up to 1024 MB (1 GB) of data. As databases comprise of only text, this is a lot of space in real terms; to put it into perspective, a WebHostsOnline Web-Solutions customer’s average database size is just 10 MB. In the rare event that you...
Can I set my database hostname as ‘localhost’?
Last Updated: May 5, 2026No, you would need to set the database hostname as the server that it’s on at WebHostsOnline Web-Solutions. You can find this by going to the MySQL Databases icon within a package. The hostname you’ll need to use will be something similiar to ‘shareddb1b.hosting.stackcp.net’ although it’s likely the database name on your package will be different. ‘localhost’...
How do I import a .sql file via phpMyAdmin?
Last Updated: May 5, 2026You can use phpMyAdmin to import an .SQL file with your database information. To do this: The .SQL file will be uploaded and imported to the database you’ve selected. WebHostsOnline Web-Solutions’s shared web hosting offers 1 GB MySQL databases.
What is MariaDB?
Last Updated: May 5, 2026MariaDB is a fork of MySQL. The database structure and indexes of MariaDB are the same as MySQL. This makes MariaDB a backward compatible, drop-in replacement for MySQL. We currently run MariaDB version 10.2.29 To check the version of MariaDB:
