Verschillen

Dit geeft de verschillen weer tussen de geselecteerde revisie en de huidige revisie van de pagina.

--- mysql [2015/05/03 15:33] – pvi
+++ mysql [Ongeldige datum] (huidige) – verwijderd - Externe bewerking (Ongeldige datum) 127.0.0.1
@@ Regel 1: / Regel 1: @@
-====== MySQL Hoofdpagina ======
-===== Exporteer alle Databases =====
-  root@gw-famnet# mysqldump --user=XXXXXXXX --password=XXXXXXX -A > /PATH/TO/DUMPFILE.SQL
-===== Exporteer meerdere databases =====
-  root@gw-famnet# mysqldump --user=XXXXXXXX --password=XXXXXXX --databases DB_NAME1 DB_NAME2 DB_NAME3 > /PATH/TO/DUMPFILE.SQL
-===== Exporteer sommige tabellen =====
-  root@gw-famnet#mysqldump --user=XXXXXXXX --password=XXXXXXXX --databases DB_NAME --tables TABLE_NAME > /PATH/TO/DUMPFILE.SQL
-===== Exporteer 1 database =====
-**Standaard SQL**  (platte tekst)
-  root@gw-famnet# mysqldump --user=databasegebruikersnaam --password=wachtwoord --databases databasenaam > /PATH/TO/bestandsnaam.sql
-**Als XML bestand**  (platte tekst)
-  root@gw-famnet# mysqldump --user=databasegebruikersnaam --password=wachtwoord --databases databasenaam --xml > /PATH/TO/bestandsnaam.**xml**
-**Gezipt XML bestand**
-  root@gw-famnet# mysqldump --user=databasegebruikersnaam --password=wachtwoord --databases databasenaam --xml | gzip -9 > /PATH/TO/bestandsnaam.gz
-===== Create database =====
-  root@gw-famnet# mysql -u root -p
-  mysql> CREATE DATABASE cms;
-===== Create database user =====
-[[https://www.digitalocean.com/community/articles/how-to-create-a-new-user-and-grant-permissions-in-mysql|Aanmaken van een user met verschillende mogelijkheden]]
-Vanaf version 5.x. :
-  mysql> CREATE USER 'gebruiker'@'localhost IDENTIFIED BY 'wachtwoord';
-  = inclusief de '
-  Query OK, 0 rows affected (0.00 sec)
-Voor oudere 4.x databases:
-  mysql> GRANT ALL PRIVILEGES ON databasenaam.* TO 'gebruiker'@'localhost' IDENTIFIED BY 'password';
-  gebruiker mag alles in de tabellen van deze database
-  Query OK, 0 rows affected (0.02 sec)
-  mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
-  mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' WITH GRANT OPTION; "user mag alles op elke db en table, incl. toekennen van opties, en dat vanaf elke machine"
-see http://dev.mysql.com/doc/refman/5.1/en/adding-users.html
-===== Importeer database =====
-  root@gw-famnet# mysql -u #username# -p #database# < #dump_file#
-===== Backup cmsms site =====
-  tar -czvf cmsms-website.tgz --absolute-names --preserve-permissions --preserve-order /var/www/cmsms
-===== Database naam en user vervangen =====
-   CMSMS : in het config.php file
-   #-----------------
-   #Database Settings
-   #-----------------
-   #This is your database connection information.  Name of the server,
-   #username, password and a database with proper permissions should
-   #all be setup before CMS Made Simple is installed.
-   $config['dbms'] = 'mysql';
-   $config['db_hostname'] = 'localhost';
-   $config['db_username'] = 'username';
-   $config['db_password'] = 'password';
-   $config['db_name'] = 'databasename';
-   #Change this param only if you know what you are doing
-   $config["db_port"] = '';
-Wijzig in het MySQL dumpfile.sql
-   \--
-   \-- Current Database: `artwam`
-   \--
-   CREATE DATABASE /*!32312 IF NOT EXISTS*/ `artwam` /*!40100 DEFAULT CHARACTER SET utf8 */;
-   USE `artwam`;
-===== Backup CMS =====
-[[cms_backup| Backup CMS]]\\
-===== WordPress Perikelen =====
-[[http://www.coolestguyplanettech.com/updating-wordpress-mysql-database-after-moving-to-a-new-url/ | URL problemen in de MySQL database]]
-===== WordPress Perikelen =====
-/usr/syno/mysql/bin/mysql -u root