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

File upload in php

Simple way to upload file using php.     //HTML code <input type="file" required="" name="avatarUrl"/>   //On action page code where form is being submitted. if($_FILES['avatarUrl']['name']!='') {                        $fileTmpPath = $_FILES['avatarUrl']['tmp_name'];           $fileName = $_FILES['avatarUrl']['name'];           $fileSize = $_FILES['avatarUrl']['size'];           $fileType = $_FILES['avatarUrl']['type'];           $fileNameCmps = explode(".", $fileName);           $fileExtension = strtolower(end($fileNameCmps));              $dateMin = date('Ymdhms');           $rand = $dateMin;    ...
Post a Comment
Read more

Setting default timezone in php.

Most of the time in shared hosting, default server time seems to be different than local timezone. You can change the default timezone using following snippet. date_default_timezone_set("Asia/Kolkata"); $dateTime = date("Y-m-d H:i:s", time()); //For full reference, visit. https://www.php.net/manual/en/timezones.php
Post a Comment
Read more