29,167
edits
Changes
m
→Using mysqldump
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=dolibarr.version.date.sql databasename
+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 dolibarr.version.date.sql where
+The result file ("dump file"), is called mysqldump_databasename_version_date.sql where
−* ''version'' is the dolibarr version (ex: 3.2).
+* ''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 ''dolibarr.3.2.20110518.sql.
+With value used as example, we will get a dump file called ''mysqldump_databasename_3.7_20110518.sql.
=== Using phpMyAdmin ===
=== Using phpMyAdmin ===