Knowledgebase
RSS Feed
Knowledgebase : Web Drive Support > Web Hosting > Manage your Server & Databases > MySQL & PostgreSQL
YES, PhpMyAdmin can be used to ADMINISTRATE [HTTPS://SUPPORT.WEBHOST.CO.NZ/INDEX.PHP?/WEBDRIVE/KNOWLEDGEBASE/ARTICLE/VIEW/449] any MySQL database.
STEP 1. Click Here to go to CONTROL PANEL [HTTPS://CONTROLPANEL.SECURESERVER.CO.NZ/] and log into you account using your USERNAME and PASSWORD STEP 2. Click on the MYSQL 5.5 DATABASES option under SERVICES tab STEP 3. Click on the  ADD A MYSQL DATABAS...
STEP 1. Click Here to go to CONTROL PANEL [HTTPS://CONTROLPANEL.SECURESERVER.CO.NZ/] and log into you account using your USERNAME and PASSWORD STEP 2. Click on the MYSQL 5.5 DATABASES option under SERVICES tab STEP 3. Click on the ADD NTH USER... link...
STEP 1. Click Here to go to CONTROL PANEL [HTTPS://CONTROLPANEL.SECURESERVER.CO.NZ/] and log into you account using your USERNAME and PASSWORD STEP 2. Click on the PSQL DATABASES option under SERVICES tab STEP 3. Click on the ADD NTH USER... link for ...
STEP 1. Click Here to go to CONTROL PANEL [HTTPS://CONTROLPANEL.SECURESERVER.CO.NZ/] and log into you account using your USERNAME and PASSWORD STEP 2. Click on the MYSQL 5.5 DATABASES option under SERVICES tab STEP 3. Click on ADMIN link next to the u...
STEP 1. Click Here to go to CONTROL PANEL [HTTPS://CONTROLPANEL.SECURESERVER.CO.NZ/] and log into you account using your USERNAME and PASSWORD STEP 2. Click on the PSQL DATABASES option under SERVICES tab STEP 3. Click on ADMIN link next to the userna...
STEP 1. Click Here to go to CONTROL PANEL [HTTPS://CONTROLPANEL.SECURESERVER.CO.NZ/] and log into you account using your USERNAME and PASSWORD STEP 2. Click on the MYSQL 5.5 DATABASES option under SERVICES tab STEP 3. Click on ADMIN link next to the u...
First, follow the instructions for administrating a PostgreSQL database [https://support.webhost.co.nz/index.php?/webdrive/Knowledgebase/Article/View/455], then use _PHPPGADMIN_ to dump the database information locally.
STEP 1. Click Here to go to CONTROL PANEL [HTTPS://CONTROLPANEL.SECURESERVER.CO.NZ/] and log into you account using your USERNAME and PASSWORD STEP 2. Click on the MYSQL 5.5 DATABASES option under SERVICES tab STEP 3. Click on DELETE DATABASE link nex...
STEP 1. Click Here to go to CONTROL PANEL [HTTPS://CONTROLPANEL.SECURESERVER.CO.NZ/] and log into you account using your USERNAME and PASSWORD STEP 2. Click on the PSQL DATABASES option under SERVICES tab STEP 3. Click on DELETE DATABASE link next to ...
If you wish to restore from a locally saved SQL file, proceed with the following instructions: STEP 1. Click Here to go to CONTROL PANEL [HTTPS://CONTROLPANEL.SECURESERVER.CO.NZ/] and log into you account using your USERNAME and PASSWORD STEP 2. Click...
If you wish to restore data from a locally backed up dump from PostgreSQL, first follow the instructions for administrating a PostgreSQL server [https://support.webhost.co.nz/index.php?/webdrive/Knowledgebase/Article/View/455] then use _PHPPGADMIN_'s rest...
STEP 1. Click Here to go to CONTROL PANEL [HTTPS://CONTROLPANEL.SECURESERVER.CO.NZ/] and log into you account using your USERNAME and PASSWORD STEP 2. Click on the MYSQL 5.5 DATABASES option under SERVICES tab STEP 3. Click on RIGHTS link next to the ...
To add rights to users of a PostgreSQL database you must log in to phpPgAdmin [https://support.webhost.co.nz/index.php?/webdrive/Knowledgebase/Article/view/455] for the database you wish to add rights to, and use the "SQL GRANT" command.
PSQL: 127.0.0.1 MYSQL 4: db.mydns.net.nz MYSQL 5: [username].mysql5.webhost.co.nz (replace [username] with your username) MYSQL 5.5: mysql3.webhost.co.nz MSSQL 2008 SERVER: mssql.mydns.net.nz MSSQL 2005 SERVER: ...
PostgreSQL [http://www.postgresql.org] is a feature-rich open-source SQL database, in fact, its slogan is "_The world's most advanced open source database_". It complies to the ANSI-SQL 92/99 standard and supports advanced features such as transactions,...
On a very basic level, MySQL can be thought of as being a "popular, easy to use and fast" database, while PostgreSQL is more "feature-rich and standards-compliant". Both can easily be used as the back end of web applications, and have fairly similar syn...
You can learn more about MySQL from the MySQL web site [http://www.mysql.com], which feature a History of MySQL [http://dev.mysql.com/doc/refman/5.1/en/history.html], a detailed list of MySQL's features [http://dev.mysql.com/doc/refman/5.1/en/features.htm...
You can learn more about PostgreSQL at the About PostgreSQL [http://www.postgresql.org/about/] page. A good set of examples and an online tutorial is available at the PostgreSQL website [http://www.postgresql.org/files/documentation/books/aw_pgsql/index...