By lanexa on

Sorry for the second post, but I didn't see this Forum the first time and I posted it originally in "Support".

I'm trying to import a database from a server running MySQL 3.23.58 to a server running 4.1.21 - both Drupal 4.7. I've checked and both MySQL versions appear to be using Latin1 as the default character set. It appears as if the import works, but there are no tables in the new database on the new server. I tried this from both the command line and from phpMyAdmin....both with no luck.

Any experiences, suggestions are greatly appreciated...I need to migrate in the coming week, else my site will go down. Thanks in advance,
Chris

⋅ Categories: Drupal 4.7.x

Comments

mr700’s picture

mr700 commented

And you get no error messages at all? How do you do it from the command line?

Try 'mysqldump -u db_user -p drupal_db > db.mysql' on the old server, drop/create a da on the new one and then 'mysql -u db_user -p new_drupal_db < db.mysql' on the new one (copy db.mysql from the old to the new server). What output/errors and tables does this give you in the new data base?

lanexa’s picture

lanexa commented

I've been posting progress in another forum, sorry about that..... Here is the what I've found so far: http://drupal.org/node/99040

Seems as if most of my issues is related to variation in the number of fields between Drupal versions....

lanexa’s picture

lanexa commented

http://drupal.org/node/99040#comment-177349. Thanks!