Importing dump file from sql

Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search. I have first created an empty database called with the same name as the. I have also tried to do it with the mysql command client using:. But it says a have an error in my SQL syntax.

Furthermore, I don't know the path where I have to set the file. When you are using mysqldump , the exported file will be saved in the current folder. It doesn't matter under what path it is. Just when importing from command line you need to be at the same folder or specify path to the file. But this isn't the case when you are using visual tool like Workbench, where you need to select the file from folder tree anyway.

And save the changes. If you are not allowed to save, then copy and paste to desktop and edit again, then paste it in the same location. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. You are quite wrong. Maybe you're connecting to a SQL Azure instance it never has been an option for that?

However the solution I am pointing about works for this case. I Hope it would help someone. Remember that this question was answered in when SQL Azure didn't exist SQL Azure does use a different mechanism, it can be backed up to blob storage as a file from within the Azure portal.

I've added the answer as I've been here looking for this and for me this answer were been useful. I am not seeing that the accepted answer is wrong, but it's a good point for those that are coming here with my use case.

Replication is not available in all editions of SQL Server. Typically you start with a backup on the destination though anyway and then need a reliable connection between both to keep the data in sync. As the OP talks about customer deployment I don't think they want to keep the data in sync — Joel Mansford. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The MySQL database application includes a command mysqldump to create a dump file of your database.

This file can be used as a backup or copied to another system. The system should display the first five lines of the dump file you have just created.

Note: The dump file is saved to the working directory you run it from. PhpMyAdmin is a handy utility for managing web servers. It includes powerful tools for graphically managing files. Enter the root password when prompted.

The system should return with Query OK, 1 row affected 0. The command prompt should return to normal. Note: These commands can all be run with a root database user account.