CODEWITHSUNDEEP
mysql
FranAguiar
FranAguiar

Reputation: 647

Copy mysql schema from a remote server to local with mysqldump

I want to copy the database schema from a remote server with mysqldump. The local database get the schema, but also, I get an error from console. 

mysqldump -h200.200.200.200 --no-data --no-create-db --single-transaction --routines -u root -psecretpass remote_db | mysql -u root -psecretpass local_db

What this's mean? Should I worry about?

ERROR 1 (HY000) at line 4158: Can't create/write to file './remote_db/db.opt' (Errcode: 2 - No such file or directory)

Upvotes: 0

Views: 349

Answers (1)

Jacques Amar
Jacques Amar

Reputation: 1833

Check if you have create procedure permissions:

--routines

Use of this option requires the SELECT privilege for the mysql.proc table. So you might get the table schema, but nor procedures and functions

Upvotes: 1

Related Questions