Database Management - AwardSpace.com https://www.awardspace.com/kb/f-a-q/database-management/ Free Web Hosting with PHP, MySQL, Email Sending, No Ads Wed, 28 Feb 2024 12:15:04 +0000 en-US hourly 1 https://wordpress.org/?v=6.8.3 https://www.awardspace.com/wp-content/uploads/2022/09/awardspace-favicon-120x120.png Database Management - AwardSpace.com https://www.awardspace.com/kb/f-a-q/database-management/ 32 32 Connect to MySQL/PostgreSQL Database: The Correct Settings for Your Script/Software? https://www.awardspace.com/kb/connect-mysql-postgresql-database-correct-settings/ Thu, 18 Mar 2021 11:45:55 +0000 https://www.awardspace.com/?p=48742 MySQL/PostgreSQL database connection can be established with script/software hosted only on your web hosting account (meaning no remote access is allowed due to security reasons). The following settings are needed: DB Host: The hostname for your database server DB Port: 3306(for MySQL) / 5432(for PostgreSQL) DB Name: The database name you have assigned DB Username: […]

The post Connect to MySQL/PostgreSQL Database: The Correct Settings for Your Script/Software? appeared first on AwardSpace.com.

]]> MySQL/PostgreSQL database connection can be established with script/software hosted only on your web hosting account (meaning no remote access is allowed due to security reasons). The following settings are needed:

  • DB Host: The hostname for your database server
  • DB Port: 3306(for MySQL) / 5432(for PostgreSQL)
  • DB Name: The database name you have assigned
  • DB Username: The database username you have assigned
  • DB Password: The database password you have assigned

You can find the above information by logging in to your hosting control panel and opening the Database Manager.

The post Connect to MySQL/PostgreSQL Database: The Correct Settings for Your Script/Software? appeared first on AwardSpace.com.

]]> How to Access Database via the Hosting Control Panel? https://www.awardspace.com/kb/access-database-via-control-panel/ Thu, 18 Mar 2021 11:44:34 +0000 https://www.awardspace.com/?p=48739 To access your database follow these steps: Log in to your hosting control panel Open the Database Manager Click on the link for the phpMyAdmin for your MySQL database or the phpPgAdmin for PostgreSQL. A new page will be loaded in a new tab where you need to enter your database credentials to access your […]

The post How to Access Database via the Hosting Control Panel? appeared first on AwardSpace.com.

]]> To access your database follow these steps:

  1. Log in to your hosting control panel
  2. Open the Database Manager
  3. Click on the link for the phpMyAdmin for your MySQL database or the phpPgAdmin for PostgreSQL.
  4. A new page will be loaded in a new tab where you need to enter your database credentials to access your database

The post How to Access Database via the Hosting Control Panel? appeared first on AwardSpace.com.

]]> How to Fix “Warning: mysql_connect(): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)” https://www.awardspace.com/kb/how-to-fix-warning-mysql-connect-cant-connect-to-local-mysql-server-through-socket-var-run-mysqld-mysqld-sock-2/ Thu, 18 Mar 2021 11:43:34 +0000 https://www.awardspace.com/?p=48737 The reason for this warning is due to the fact that you are using localhost as the hostname for your database in your script. Please note that localhost is used only when your web and database are located on the same server. On our hosting platform, the database is located on a separate server. In […]

The post How to Fix “Warning: mysql_connect(): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)” appeared first on AwardSpace.com.

]]> The reason for this warning is due to the fact that you are using localhost as the hostname for your database in your script. Please note that localhost is used only when your web and database are located on the same server. On our hosting platform, the database is located on a separate server. In order to connect to your database, you must use the hostname for your database. You can find this information inside the Database Manager of your hosting control panel.

The post How to Fix “Warning: mysql_connect(): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)” appeared first on AwardSpace.com.

]]> I am trying to access MySQL via the SSH command line, what is the path to MySQL command via SSH? https://www.awardspace.com/kb/i-am-trying-to-access-mysql-via-the-ssh-command-line-what-is-the-path-to-mysql-command-via-ssh/ Thu, 18 Mar 2021 11:41:58 +0000 https://www.awardspace.com/?p=48734 To connect to your database via SSH using the following command: mysql -h db_host_name -D db_name -u db_username -psomepass You can find the necessary information inside the Database Manager of your hosting control panel.

The post I am trying to access MySQL via the SSH command line, what is the path to MySQL command via SSH? appeared first on AwardSpace.com.

]]> To connect to your database via SSH using the following command:

mysql -h db_host_name -D db_name -u db_username -psomepass

You can find the necessary information inside the Database Manager of your hosting control panel.

The post I am trying to access MySQL via the SSH command line, what is the path to MySQL command via SSH? appeared first on AwardSpace.com.

]]> The SQL Server is Rejecting any INSERT Queries. Why? https://www.awardspace.com/kb/the-sql-server-is-rejecting-any-insert-queries-why/ Thu, 18 Mar 2021 11:41:07 +0000 https://www.awardspace.com/?p=48732 Please note that some of our hosting packages have a set limit for maximum database size. If you have reached the limit, the SQL server will reject any inserts. You can check the current disk usage from the Database Manager inside your Hosting Control Panel. For more detailed information on how to optimize your database […]

The post The SQL Server is Rejecting any INSERT Queries. Why? appeared first on AwardSpace.com.

]]> Please note that some of our hosting packages have a set limit for maximum database size. If you have reached the limit, the SQL server will reject any inserts. You can check the current disk usage from the Database Manager inside your Hosting Control Panel.

For more detailed information on how to optimize your database and deal with this error please refer to the following article here.

The post The SQL Server is Rejecting any INSERT Queries. Why? appeared first on AwardSpace.com.

]]> Why in phpMyAdmin there is an error message “You have no privileges”? https://www.awardspace.com/kb/why-in-phpmyadmin-there-is-an-error-message-you-have-no-privileges/ Thu, 18 Mar 2021 11:40:15 +0000 https://www.awardspace.com/?p=48730 The only privileges that your database does not have are CREATE DATABASE. If you wish to add new databases, please use the Database Manager.

The post Why in phpMyAdmin there is an error message “You have no privileges”? appeared first on AwardSpace.com.

]]> The only privileges that your database does not have are CREATE DATABASE. If you wish to add new databases, please use the Database Manager.

The post Why in phpMyAdmin there is an error message “You have no privileges”? appeared first on AwardSpace.com.

]]> Is the InnoDB Storage Engine Supported on AwardSpace’s Servers? https://www.awardspace.com/kb/is-the-innodb-storage-engine-supported-on-awardspaces-servers/ Thu, 18 Mar 2021 11:38:39 +0000 https://www.awardspace.com/?p=48727 The InnoDB storage engine is supported on our hosting plans. You can change the storage engine for your table via phpMyAdmin. You can access the phpMyAdmin from the Hosting Control Panel > Database Manager. Once you are in the Database Manager click the phpMyAdmin link. Our article for reducing the size of a database contains […]

The post Is the InnoDB Storage Engine Supported on AwardSpace’s Servers? appeared first on AwardSpace.com.

]]> The InnoDB storage engine is supported on our hosting plans. You can change the storage engine for your table via phpMyAdmin. You can access the phpMyAdmin from the Hosting Control Panel > Database Manager. Once you are in the Database Manager click the phpMyAdmin link.

Our article for reducing the size of a database contains instructions on how to convert a table to use the InnoDB engine.

The post Is the InnoDB Storage Engine Supported on AwardSpace’s Servers? appeared first on AwardSpace.com.

]]> Can I Manage my Database Created Through the Hosting Control Panel from my Personal Computer? https://www.awardspace.com/kb/manage-database-through-the-hosting-control-panel-from-personal-computer/ Thu, 18 Mar 2021 11:36:58 +0000 https://www.awardspace.com/?p=48719 Access to the MySQL and PostgreSQL servers has been restricted on all shared hosting plans. If you want to manage your MySQL or PostgreSQL databases, please do so from the phpMyAdmin and phpPgAdmin sections from your Hosting Control Panel -> Database Manager.

The post Can I Manage my Database Created Through the Hosting Control Panel from my Personal Computer? appeared first on AwardSpace.com.

]]> Access to the MySQL and PostgreSQL servers has been restricted on all shared hosting plans. If you want to manage your MySQL or PostgreSQL databases, please do so from the phpMyAdmin and phpPgAdmin sections from your Hosting Control Panel -> Database Manager.

The post Can I Manage my Database Created Through the Hosting Control Panel from my Personal Computer? appeared first on AwardSpace.com.

]]> How can I export a database using phpMyAdmin? https://www.awardspace.com/kb/how-can-i-export-a-database-using-phpmyadmin/ Thu, 18 Mar 2021 11:30:32 +0000 https://www.awardspace.com/?p=48718 Log into phpMyAdmin from your Control Panel->Database  Manager section using your Database Username and Database Password. Once you are inside the phpMyAdmin application click on the Export link and choose to export the database in SQL file. Last you should click on the Go button.

The post How can I export a database using phpMyAdmin? appeared first on AwardSpace.com.

]]> Log into phpMyAdmin from your Control Panel->Database  Manager section using your Database Username and Database Password. Once you are inside the phpMyAdmin application click on the Export link and choose to export the database in SQL file. Last you should click on the Go button.

The post How can I export a database using phpMyAdmin? appeared first on AwardSpace.com.

]]> How can I export a database using SSH? https://www.awardspace.com/kb/export-database-ssh/ Thu, 18 Mar 2021 11:26:20 +0000 https://www.awardspace.com/?p=48717 You need to create an SSH account from your Control Panel > Hosting Tools > SSH Manager section. To export a database use your configured SSH account by executing the following command through SSH: mysqldump -h [DB HOST] -u [DB USER] -p[DB PASS] [DB NAME] > /home/www/database.sql All the database settings – [DB HOST], [DB […]

The post How can I export a database using SSH? appeared first on AwardSpace.com.

]]> You need to create an SSH account from your Control Panel > Hosting Tools > SSH Manager section.

To export a database use your configured SSH account by executing the following command through SSH:

mysqldump -h [DB HOST] -u [DB USER] -p[DB PASS] [DB NAME] > /home/www/database.sql

All the database settings – [DB HOST], [DB USER], [DB PASS], and [DB NAME] should be written exactly as they are displayed in your Hosting Control Panel -> Database Manager section.

The database will be exported into your hosting account and you will be able to find it at /home/www/database.sql.

You can change the export path by simply editing the last part of the command.

The post How can I export a database using SSH? appeared first on AwardSpace.com.

]]>