I;m trying to move a database created with WAMP from one computer to another. I've exported it as a .sql file and imported it by creating a new database and then importing into it. The problem I'm facing with this approach is that none of the data in the tables gets imported and I haven't been able to figure out how to get both the database structure AND its data.
dyingatmidnight
0
Junior Poster
Recommended Answers
Jump to PostHow exactly did you export and import it and what error message do you get? Use mysqldump for export and the mysql command line interface for import. Make sure that the mysql user account on the import side has the right to create tables.
Jump to PostLike I said: use mysqldump and the mysql command line. That way you'll get a clean database dump and all error messages.
All 6 Replies
smantscheff
265
Veteran Poster
dyingatmidnight
0
Junior Poster
smantscheff
265
Veteran Poster
dyingatmidnight
0
Junior Poster
smantscheff
265
Veteran Poster
dyingatmidnight
0
Junior Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.