Scubians » Blog Archive » Export and Import MYSQL Linux commands

< Browse > Home / Mysql, Php / Blog article: Export and Import MYSQL Linux commands

Export and Import MYSQL Linux commands

May 14th, 2009 | No Comments | Posted in Mysql, Php

Export

steps:

1) mysqldump -u web_user -p databasename > sqlfilename

2) Prompts you to enter Password:

3)Enter the password then the database will be backup on given sqlfile

Import

mysqldump -u web_user -p database_name < sqlfilename

Leave a Reply 171 views, 1 so far today |

Tags: backup, export, import, linux, Mysql, mysqldump

Leave a Reply

You must be logged in to post a comment.

We are Watching

Jquery google

High performance

Web development

Jquery googlepart1

Jquery googlepart2

Powered with ByREV Video Gallery Wordpress Plugin

Recent Post

Popular Post

Updated Post

Twitter

Tag Cloud

Add new tag apache caching child client Code layout Coding compiled compression configuring content css debug deployment Editor settings Firebug Guide lines html http Hyderabad Javascript linux maximum memory modules Mysql Naming convensions performance Php PHP-Mysql Plugin process processes Query log request requests response Scube server Services Softwares Solutions Standards Web development Word press
WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

©2008 Scube