pixeltrace Posted September 5, 2007 Share Posted September 5, 2007 hi, need help, what is the mysql command to dump database? i have a database.sql database file and the database name is not yet existing. i tried mysqldump -h localhost > database-db.sql mysqldump: Got error: 1049: Unknown database 'opencms' when selecting the database but i am getting an error and i dont think i am using the correct command. hope you could help me with this. thanks! Quote Link to comment https://forums.phpfreaks.com/topic/67996-how-to-dump-database/ Share on other sites More sharing options...
gigantorTRON Posted September 5, 2007 Share Posted September 5, 2007 If you are trying to backup your database: # mysqldump -uuser -p database_name > file_name.sql To dump your backup file to a new database, make sure you have created the database and then: mysql -uuser -p database_name < backup_name.sql and that should work! Quote Link to comment https://forums.phpfreaks.com/topic/67996-how-to-dump-database/#findComment-342085 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.