Oracle/MSSQL/MySQL

How to Backup MySQL Databases from the Command Prompt (Line)

How to Back Up MySQL Databases From The Command Line

http://www.linuxtweaker.com/linux/how-to-export-and-import-mysql-database-via-command-line-in-linux/
https://www.howtoforge.com/faq/how-to-use-the-command-line-to-make-an-sql-dump-of-a-mysql-database

Note: plxxx.ixxx is a given name for the directory

Creating A Backup
christian@wxx10:/etc$ cd /var/www/plxxx.ixxx

christian@wxx10:/var/www/plxxx.ixxx$ ls
cgi-bin index.html log private ssl tmp web webdav

christian@wexx0:/var/www/plxxx.ixxx$ cd web
-bash: cd: web: Permission denied

christian@wxx10:/var/www/plxxx.ixxx$ ls
cgi-bin index.html log private ssl tmp web webdav

christian@wexx0:/var/www/plxxx.ixxx

Step 1. Instead of entering passwords always to change into the web directory use the sudo -i command

christian@wexx0:~$ sudo -i
[sudo] password for christian:
wexx0#

wexx0# cd /var/www/plxxx.ixxx

wexx0# ls
cgi-bin index.html log private ssl tmp web webdav

wexx0# cd wexx0# cd web

wexx0# ls
basic.css css_brands.css css_start.css ie6.css LGPL.txt navi_grey.css navi_trading.css share.php system
CHANGELOG.txt css.css css_trading.css index.php navi_brands_bak.css navi_saas.bak.css plugins sitemap_en.xml templates
contao css_grey.css error INSTALL.txt navi_brands.css navi_saas.css print.css sitemap.xml tl_files
cron.php css_saas.css GPL.txt lang.css navi.css navi_trading_bak.css robots.txt stats typolight

Note: This is for contao setup in other to get the username and passord as well as the database
name for creating the mysql dump and this is different for vtiger files.

For Contao Db can be found in the path below

/var/www/plxxx.ixxx/web/system/config/Cat localconfig.php

For vtiger Db it can be found

/var/www/vtiger.plxxx.ixxx.info/web/wexx0#Cat config.db.php

https://wiki.vtiger.com/index.php/Migrating_vtiger_source_and_database_from_one_machine_to_another_one_on_Windows

After getting the database information simply follow step 2 below

wexx0# cd system

wexx0# ls
config contao.css functions.php iefixes.css interface.php logs modules tmp onstants.php drivers html initialize.php libraries mbstring.php themes utf8_lookup.php
wexx0# cd config/

wexx0# ls
config.php dcaconfig.php fancyUpload.php langconfig.php localconfig.php timezones.php tinyMCE.php
countries.php editArea.php initconfig.php languages.php tcpdf.php tinyFlash.php tinyNews.php
web10# cat localconfig.php
wexx0# cat localconfig.php

http://www.linuxtweaker.com/linux/how-to-export-and-import-mysql-database-via-command-line-in-linux/
http://www.liquidweb.com/kb/how-to-back-up-mysql-databases-from-the-command-line/

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x