31,029
edits
Backups: Difference between revisions
Jump to navigation
Jump to search
m
→Using mysqldump
m (→The database) |
|||
| Line 65: | Line 65: | ||
With Mysql, the command to backup your database into a file is : | With Mysql, the command to backup your database into a file is : | ||
<source lang="bash"> | <source lang="bash"> | ||
mysqldump -u user -pyourpass --result-file= | mysqldump -u user -pyourpass --result-file=mysqldump_databasename_version_date.sql databasename | ||
</source> | </source> | ||
where : | where : | ||
| Line 73: | Line 73: | ||
Those informations (user, password and database) are available into your configuration file ''dolibarrdir/htdocs/conf/conf.php'' | Those informations (user, password and database) are available into your configuration file ''dolibarrdir/htdocs/conf/conf.php'' | ||
The result file ("dump file"), is called | The result file ("dump file"), is called mysqldump_databasename_version_date.sql where | ||
* ''version'' is the dolibarr version (ex: 3. | * ''version'' is the dolibarr version (ex: 3.7). | ||
* ''date'' can be replaced with a date, recommanded format is YYYYMMDD, with YYYY the year (ex. 2011), MM is month number (ex. 05) and DD is day in month (ex. 18). | * ''date'' can be replaced with a date, recommanded format is YYYYMMDD, with YYYY the year (ex. 2011), MM is month number (ex. 05) and DD is day in month (ex. 18). | ||
With value used as example, we will get a dump file called '' | With value used as example, we will get a dump file called ''mysqldump_databasename_3.7_20110518.sql. | ||
=== Using phpMyAdmin === | === Using phpMyAdmin === | ||