1. How-to create a MySQL database and assign user privileges to it?
(Databases/mySql)

Question: How-to create a MySQL database and assign user privileges to it? NOTE: Please note that this is done in the Command Line Interface.   Answer:  First login to the mySql server using root. ...

2. How to Export your MySQL database schema to a file using the Command Line?
(Databases/mySql)

Question: How to Export your MySQL database schema to a file using the Command Line?   Answer:  Use the following command in the Command Line Interface mysqldump --no-data --tables -uMYSQL_USER_NAME ...

3. How to execute SQL commands from a file in postgresql?
(Databases/pgsql)

... steps Connect to the relevant database eg. sudo -u postgres psql MYDB Then run \i MYFILEWITHCOMMANDS.sql\i means execute commands from file All commands will be executed.    ...

4. How to get random rows when querying a database table using mySql?
(Databases/mySql)

Question: How to get random rows when querying a database table using mySql? For example if you have a table with 100 rows in it and you need to get 3 random rows then this could come in handy.   Answer: ...

5. How to list all Postgres databases using the Command Line?
(Databases/pgsql)

Question: How to list all Postgres databases using the Command Line?   Answer:  Type in the following command in the CLI (Command Line Interface) psql -l This command will list all of the databases ...

6. How to delete a column in a database table using postgres via the command line?
(Databases/pgsql)

Questions: How to delete a column in a database table using postgres sql via the command line?   Answer: Use the following statement ALTER TABLE my_table DROP COLUMN my_column; Replace my_table with ...

7. Error: "Ignoring query to other database" when running a mySql command in the command line
(Databases/mySql)

Question: I get the the following error: "Ignoring query to other database" when running a mySql command in the command line. Eg. SELECT  * FROM users; or SHOW tables;   Answer:  In the command line ...

8. How to export a mySql database to a file via the Command Line in Linux?
(Databases/mySql)

Question: How to export a mySql database to a file via the Command Line in Linux?   Answer: Open a new Terminal Window Type in the following command mysqldump -uUsername -pPassword DatabaseName ...

9. How to import a generated mySql file '.sql' via the CLI (Command Line Interface)?
(Databases/mySql)

... -uusername -ppassword databasename < import.sql MS Dos mysql -u username -p databasename < import.sql  ...

10. Editing the pg_hba.conf file on a postgresql database server so that a specific (other) server will be able to connect to the postgresql database server
(Databases/pgsql)

Editing the pg_hba.conf file on a postgresql database server so that a specific (other) server will be able to connect to the postgresql database server. Example: Say I have a server where all of my postgresql ...

11. How to change the root mySql password with mySql installed on Ubuntu/Linux?
(Linux/Linux)

... the user table in the mySql database. Open a new Terminal Window and type in the command below to Login to the mySql server. mysql -u root -p Enter your password. Now you need to switch to the mysql database. ...

12. How to export data to a CSV file from a postgres database
(Databases/pgsql)

Question: How to export data to a CSV file from a postgres database?   Answer:  Type in the following command in postgres using the command line: copy products to '/home/user/products.csv' delimiters ...

13. How to export data to a CSV file from a postgres database together with table headings?
(Databases/pgsql)

Question: How to export data to a CSV file from a postgres database together with table headings?   Answer:  Type in the following command in postgres using the command line: copy products to '/home/user/products.csv' ...

14. How to import a CSV file into a postgres database table?
(Databases/pgsql)

Question: How to import a CSV file into a postgres database table?   Answer:  Type in the following command in postgres using the command line: copy products from '/home/user/products.csv' using ...

15. How to backup a mySql database in Ubuntu?
(Databases/mySql)

Question: How to backup a mySql database in Ubuntu using the mysqldump utility?   Answer:  Open a new Terminal Window. Type in the following command: mysqldump -h localhost -u root -pPASSWORD database ...

16. How to create a backup of a postgres database to a sql file?
(Databases/pgsql)

Question: How to create a backup of a postgres database to a sql file? This sql file then can be used to restore the database on a later stage.   Answer: Follow the steps below in order to create ...

17. Error: "Could not complete the operation due to error c00ce56e" while using Ajax
(Ajax/Ajax)

... charset="utf-8"); //This piece of code I added where I create my Database connection mysql_query("SET NAMES 'utf8'"); After adding these lines it worked in perfectly Internet Explorer 7.  ...

18. How to create a complete Backup of your Joomla! website
(Joomla! Tutorials/Joomla! Tutorials)

To Backup your Joomla! Website you need to have your FTP details ready. You need to create a complete Backup of all your Joomla! Files and also a Backup of your mySql database witch keeps important information ...

19. Setting the File permissions in Joomla!
(Joomla! Tutorials/Joomla! Tutorials)

... as secure as possible is to make your files and folders as secure as possible. You can start of by setting the file permissions. And of course please ensure that you always have a backup of your Database ...

20. How do I upgrade to Joomla! 1.5 ?
(Joomla! Tutorials/Joomla! Tutorials)

... migration export and click on Upload and Execute A success message should appear or alternately a listing of database errors Complete the other required fields in the Configuration step such as Site ...