Export Database

Hi all, we currently have Omeka Classic that is managed by a hosting provider and will now be going at this alone on our own server. Can anyone share with me the what the best way will be for us to move our entire site from one server to another? Could this be as simple as using mysqldump and creating a dump? Does anyone have experience with this method?

I am not concerned about the customization of the site, but rather I would like to export and import the collections and items as is.

Thank you for any input and for the help and support.

Hi @erhistoricalsociety,

That’s how I would typically move a site. You just create a dump of the database and then import it into your new database. You would also download all of your files and transfer them to your new server.

Okay, thank you. That was my thought process but wanted to confirm that this would be the best way. I appreciate the help and support.

Thanks for all your help and support. I ran through all of this today and it was somewhat a success except for Omeka logging me out after I imported the mysql dump into the new database. I am now unable to login to Omeka. It appears that the user I created has been deleted and replaced with one I am unfamiliar with. Any thoughts?

@erhistoricalsociety, I would start by checking that you dumped the users table and that it was imported. If not you you could try just importing the users again.

Thank you! This has been solved.

This worked great, but I was also thinking I could move the files in the Omeka folder up one level into the html folder to avoid having a subdirectory. Everything moved perfectly, but when I click on an item or collection I get an error that says the requested URL is not on this server. I am thinking something needs to be changed in one of the .ini files but I am not sure which one. Any thoughts?