Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By pauldreed on
I want to move the entire drupal 5 site to a different domain name, but struggling with the database.
How can you move or import the database into the site?
I have tried dumping the existing database to my PC and via PHPMyAdmin uploading it from the SQL tab, but the database remains unchanged with no tables created.
Is there an easier way?
Comments
The better option will be to
The better option will be to use MySQL on the command line, but for PHPMyAdmin, I also noticed that it often bombs without any error message (just a blank page). I then export only some tables at a time to plain text (not GZipped etc.) and it does give an error some of the time:
When I exported from one server and imported to another it often gave errors on things like the SQL syntax (different versions of SQL) or the character sets. I think PHPMyAdmin has compatibility modes for export and import that may take care of that, but haven't tried it yet, opting for the command line when things go wrong.
When you simply send too many INSERTs it bombs with no error message, blank page. I just exported once to plain SQL and then used a text editor to cut the file into smaller chunks to import. It worked, but it is tedious.
Rather Google "MySQL import" and hit the command line.
Your host provider....
This may or may not be a possibility... however, most (at least in my experience) hosting providers will perform the transfer for you. That is... if you're hosting your site in shared environment.