mysql

L'envoi a échoué. Les autorisations sont-elles correctes ?

Différences

Ci-dessous, les différences entre deux révisions de la page.

Lien vers cette vue comparative

mysql [2019/08/28 09:10] (Version actuelle)
Ligne 1: Ligne 1:
 +====== Pepper One and mySQL ======
 +
 +mySQL is used by Pepper One product'​s as open source alternative of MS SQL with licence cost.
 +
 +For this, we have made a special section to explain how you can use it.
 +
 +===== Installation =====
 +
 +We use specific version of mySQL : 
 +
 +  - mySql server 5.1.42 (win 32 bit) : [[http://​support.pepper1.be/​images/​belgo2/​mysql-essential-5.1.49-win32.msi|Download]]
 +  - mySql GUI tools (win 32 bit) : [[http://​support.pepper1.be/​images/​belgo2/​mysql-gui-tools-5.0-r17-win32.msi|Download]]
 +
 +There are new GUI tools like mySQL workbench but we prefere mySQL Query Browser for the simple use.
 +
 +===== Tuturials =====
 +
 +  * SQL tutorials : http://​www.w3schools.com/​sql/​default.asp
 +
 +===== Backup =====
 +
 +Two kind of backup are prefered : 
 +
 +- SQL Dump using mySQL administrator (see mySQL GUI tools)
 +- SQL xTrabackup ​
 +
 +==== Backup SQL Dump ====
 +
 +Using mySQL administrator,​ you can backup and restore SQL dump (text file). This can be done every day on specific hour. The database must not be shutdown, But somes lock can be done to execute "​coherent dataset"​.
 +
 +{{http://​support.pepper1.be/​images//​1290784379061.jpg}}
 +
 +We can use the restore function to replace database with a dump file
 +
 +More information can be found at [[http://​dev.mysql.com/​doc/​refman/​5.1/​en/​backup-and-recovery.html|mySql]]
 +
 +==== Backup xTrabackup ====
 +
 +A another way is to use for larger database, [[http://​www.percona.com/​docs/​wiki/​percona-xtrabackup:​start|xTrabackup]] to make rapid and efficient backup.
 +
 +For exemple : 80GB in 1 hour
 +
 +  * Making a backup (make a copy in mysql data folder)
 +
 +    xtrabackup --backup
 +
 +  * Restore a backup ​ (you should be in the data's folder)
 +
 +    xtrabackup --prepare --target-dir=.
 +
 +Don't forget to copy the table'​s definition.
 +
  
  • mysql.txt
  • Dernière modification: 2019/08/28 09:10
  • (modification externe)