MYSQL dump file using command prompt ?

First of all ,go to mysqldump utility folder eq. C:\wamp\bin\php\php5.3.0 using commad prompt and then type following code.

in this example wordpress database has username root without password.
login into command prompt if you are using XAMPP please follow following Step



step 1.  cd  c:\xampp\mysq\bin

Method 1.  mysql -u root -p -h localhost databasename < file.sql


file must save in your c:\xampp\mysql\bin


Method 2. >mysqldump --opt --user=root --password= wordpress > mydata.sql

Most Popular

How to send emails using PHPmailer and GMAIL SMTP

Image
Here I have tried how to send PHPMailer with attachement using SMTP configuration. For SMTP Configuration we here used GMAIL Auth. You can used any Auth like SMTP2GO , SendGrid . Download PHPMailer library. PHPMailer Sample Code Addd or Copy paste the following code in your editor and save with any filename with extension ".php" and try in your live server or local server. But Make sure you have to connect with internet with proper Auth details <?php require_once('phpmailer/PHPMailerAutoload.php'); $mail = new PHPMailer(); $mail->CharSet = "utf-8"; $mail->IsSMTP(); // Set mailer to use SMTP $mail->SMTPDebug = 1; // Enable verbose debug output $mail->SMTPAuth = true; // Enable SMTP authentication $mail->Username = "xxx@example.com"; //Your Auth Email ID $mail->Password = "xxxxxx"; //Your Password $mail->SMTPSecure = 'tls'; // Enable TLS encryption, `ssl` also accepted $mail->Host = "...
Keep reading

The difference between React vs AngularJs

Image
React and AngularJs are currently using Travel and News companies. Main reason difference between AngularJs and ReactJs is AngularJS 1. AngularJs is MVC framework library. It is used for Two-way data binding. 2. AngularJs is an App development framework. ReactJS 1. React Js is a Library. It is used for One-way data binding. 2. ReactJs is an interface development framework. AngualrJs is a Javascript Framework. Where we can add HTML tags with Scrip tag. It is a Library written in Javascript. AngularJs developed by GOOGLE. AngularJs similar to Backbone or JavascriptMVC. It is a complete solution for rapid development. Following are some Features of AngularJs. 1. REST Easy: RESTful action quick communication between server to the client. 2. Extends HTML: AngularJS extends HTML with ng-directives. The ng-app directive defines an AngularJS application. The ng-model directive binds the value of HTML controls (input, select, textarea) to application data. The ng-bi...
Keep reading

How to work code-igniter project in sub-folder

When this happens when you have 2 .htaccess files in the server. Very simple solutions just add following code and your code-igniter project will work in sub-folder. RewriteEngine on RewriteCond $1 !^(index\.php|images|robots\.txt) RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule ^(.*)$ /admin/index.php?/$1 [L]
Keep reading