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

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

multithreading - Exception in Application constructor -

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -