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/
Short & to the point working PHP snipes.