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! 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! Link to comment https://forums.phpfreaks.com/topic/67996-how-to-dump-database/#findComment-342085 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.