I will most likely try to move the forum during this weekend, so expect some downtime during saturday or sunday, can’t say when it’ll be, but I’m sure you’ll notice it.
I wish you luck
Good luck Mikke
Hopefully it’ll go through this time
Once you have migrated can you set the default theme to “EAF New Theme” and not “EAF copy”
I might need to get in to make a couple of changes to the theme also, regarding some file locations once it installed.
Damn, it would have been faster and easier to build a new server from scratch, install OS and everything, then to trying to export/import.
I have now tried to exchange all the references to the from “vbulletin” to “newdbname”, and it worked fine with the smallest file (I think, at least I could import it), but when trying the same with the larger files they are so big that the computer(s) get stuck when trying to work with them, and then I either use search and replace and exchange every instance of vbulletin (including posts and everything) or I miss instances where it should have been replaced. Frustrating and improductive? YES!
What are you using to import export
SQLyog has a migrate feature. You just connect to the old server and new server and click a button.
It’s worked well for me in the past
Just installed yog and it still migrates SQL from server to server, even large files
MySQL Administrator on my server to make a back-up. phpMyAdmin to import into the new server.
If I could export the database with the new name with size limited to less then 128Mb, I’m sure it would work just fine, but I don’t find any possibility to exchange the name of the database while exporting it.
ETA: There is a migration tollkit included with MySQL, have to chack if that is possible to use for exporting…
Without seeing exactly what your are trying to do it is difficult.
But I would create the new database on the new server and then just import the tables. I wouldn’t try to create the database at the same time.
SQLYog is able to do this. You just export the tables from one database on one server to the database on another server.
Even large files.
The problem is that I can’t create a new database on the new server and have it use the same name as I use on my own server. The name have to start with my account number for the hosted server, and with that the name will of course be different from the database name on the old server.
I tried the migration tool kit, but I can’t get it to connect to the new MySQL-server.
And now I’ve run out of time and patience for today, about to starve to death on top of everything…
You could call the new database what ever you want. You only need to move the contents of the databases not the actual database
It’s phpmyadmin is the weak link. The file size limit is due to that. Not your webspace.
The very latest phpmyadmin builds have supposed to stopped limiting the size of the data.
You must be using an older version.
I never use it. It’s a pain in the arse tool.
If you give me access I’ll copy the tables across. I can do it very late tonight if you want.
I could do a test now, by copying the database tables to a temp database on my space if you like. Just to confirm it can be done.
I have just tested a database move from my PC to my webspaces and that has a very limited 2 meg db limit. using a 3 meg db in SQLyog went OK.
Copying the tables only from one database to another, both databases named differently.
PHPMyAdmin might be shit, but it’s what offered. I’ll try to talk to their support tomorrow and see if they can help me set up a direct connection so I can use the migration tool.
SQLyog is a tool you can use. One that I use. I hardly ever use phpmyadmin, it is only ever offered as a solution by webhosts because it’s open source.
If you gave me access to the databases, even for only an hour, I could copy the data over.
The only issue I can foresee is if the new provider has a firewall in place, in which case we’d need to get them an IP to allow data through from an external db manager
I support DBA’s for a living, it’s what I do.