Skip to main content

Connecting mysql using cmd

 Local your Mysql >> Bin folder & open the command prompt here.


to connect MySQL remotely --

>> mysql -h hostname -u username -p

hostname is your hostname, username is user database username, leave -p as it is. cmd prompt will ask you to enter password. Once connected you can fire any SQL command.


Import large file ingoring errors.

>> mysql -u userName -p -f -D dbName < script.sql


Dump backup to local file.

>> mysqldump -u [user name] –p [password] [options] [database_name] [tablename] > [dumpfilename.sql]

for more,
https://www.sqlshack.com/how-to-backup-and-restore-mysql-databases-using-the-mysqldump-command/

Comments

Post a Comment

Popular posts from this blog

Restoring MySQL on XAMMP

  Follow these steps and save your time and databases:- Go to your  XAMMP  installation, it’s mostly in  C drive . Now inside  mysql  folder rename the folder  data  to  data-old  (or any other name you like) Create a new folder  data  under  mysql  folder Copy the contents of  backup  folder to the new  data  folder Now copy all your  database  folders that are in  data-old  folder to the new  data  folder (skip the mysql, performance_scheme and phpmyadmin folder) And the last, copy the  ibdata1  file from  data-old  folder and replace it inside new  data  folder Restart your  MYSQL  server from  XAMPP control panel . And done!
Post a Comment
Read more

Simple method to connect database using PHP.

    $servername = "localhost"; $username = "root"; $password = ""; $dbname = "jjmtmain"; // Create connection $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) {     die("Connection failed: " . $conn->connect_error); } else {     echo "Connected to database."; }  /* In further operations you can use the $conn object for the database connection.              For eg. $q = mysqli_query($conn, "select * from user where email='$userid'"); $r = mysqli_fetch_array($q); echo $name = $r['name']; */
Post a Comment
Read more