ubuntu - ubunutu commands to upload sql file to database -
there database file in path : /var/www/db.sql in our server.
size of .sql file 800mb.
we have upload sql file database name : "age"
username : root, password : pass , database password : dbpass
i trying command . not working.
mysql -u root -ppass age db.sql please give correct command or missing path of sql file?
please guide me this.
you can use code:
mysql -uroot -ppass age < /var/www/db.sql or better is:
mysql -uroot -p age < /var/www/db.sql passing password mysql argument unsecure.
Comments
Post a Comment