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