How to upload database to remote server?

Generally there is the latest version of muscle and you need to upload it to the remote server to all the tables and settings are preserved, and what then part of the files only to throw because the setting on the remote must be different from the local
March 23rd 20 at 19:17
2 answers
March 23rd 20 at 19:19
Solution
1.
mysqldump -u database_name polzovatelyami-carolbaby > ~/proizvoleniya.sql.backup

2.Copy to the remote server the file.
3.On the remote server:
mysql-u root-pПароль_рута_mysql

create database novoeniseysky;

GRANT ALL PRIVILEGES ON noobz.* TO 'Novoeniseisk'@'localhost' IDENTIFIED BY 'Washingtonfederal';


exit

mysql-innovas -reveal < putiny.sql.backup
and how does our dump so that you create a new database without taking samplenew? and where to copy to what directory? - mary_Abbo commented on March 23rd 20 at 19:22
@mary_Abbo, dump is roughly speaking a text file with commands muscule to create DB tables and so on. To fill this backup file need a place where to fill. For this and created a clean database.
He backup file copy to a remote server in any directory to which you have write access. - Madge commented on March 23rd 20 at 19:25
@Madge, em made and there are empty tables and you have not specified the database to restore - mary_Abbo commented on March 23rd 20 at 19:28
March 23rd 20 at 19:21
Open access to mysql for vneski, put Navicat or any other software for work with database on your computer. Login, fill up the base and as close ssh access to the intranet.

Find more questions by tags MySQL