Sloppy 1&1

Posted by libre fan on February 27, 2008 at 7:04pm

Hello,

I've had some problems in upgrading from 5.7 to 6 because 1&1 didn't upgrade MySQL on older DBs.

see Mysql warnings: SELECT vid , duplicate key, etc

So they tell me to create a new DB and migrate my data into it?

Do you know how to do that? Do you need to export then import your old BD thruough PHPMyAdmin?

Not very convenient, I'm afraid.

Comments

yep, export the original,

Posted by Quint on February 27, 2008 at 8:28pm

yep,

export the original,
create a new DB,
create a new user
add the user to the DB
go into PHPMyAdmin and import the original DB

If you delete your original DB after you export it, you can create the new DB with the same name as the original, If you create the new DB name, user and password the same as the original, you won't have to edit files.

If you create the new DB while the old DB still exists, you'll have to create a new DB name and therefore edit your settings.php file to contain the new name.

Still some questions on DB migration on 1&1

Posted by libre fan on February 29, 2008 at 2:04pm

Many thanks for your help Quint!

I will try that as soon as I have access to a DSL connection.

Before upgrading from 4.7.6 I exported the DB.

My questions are:

1. The present DB is on Mysql 4.0 and upgraded to Drupal 6. Of course they are some warnings and an error. Can I still export it and import it under a new DB with Drupal6 installed or will that create problems?

Would it be safer to import the old backup Drupal 4.7.6 DB on the new DB, then install Drupal 4.7.6, then upgrade to Drupal 4.7.11, then to Drupal 5.0, then to Drupal 5.7, and finally to Drupal 6.0, and again finally to drupal 6.1? :-\

2. How do I associate the new DB to my domain name? Simply through Drupal's settings file?

Conclusion: I wouldn't recommend 1&1 as I think a commercial host should upgrade Mysql on older and newer DB whatever. Shame on them!

I'm glad Wordpress.com is there for you to set up a web site in a tick!

---
Libres-Ailé(e)s (Association for Linux and libre software) (France, Cévennes)

---
http://librefan.eu.org/ Libre-Fan (Mozilla, GNU/Linux, le Libre [et les femmes?]), France

If you have 4.7 working,

Posted by Quint on February 29, 2008 at 3:38pm

If you have 4.7 working, just upgrade the DB version first, so you can revert if necessary.

Create a new db with a different name, import your exported DB, change the settings.php to the new db name.

I'm sure they didn't upgrade existing DBs because some will break and then they'd have people screaming that they should have left them alone. Isn't 1&1 one of the super-cheap hosts anyway?

Learning slowly: importing big DB (exceeding PHP limits)

Posted by libre fan on March 3, 2008 at 6:13pm

I've had a look around, and I've found out you can import your sql DB through the shell, and OpenSHH which is installed on Ubuntu (and Debian). I'll post a short howto when Drupal runs as it should, considering the present mess (not Drupal fault and not my own entirely).

Fisrt, I created a new db and installed Drupal. Then I thought it would be better not to install Drupal (I suppose Drupal builds tables while installing) at all but simply create a new DB, upload the Drupal files and dirs, import the old Drupal DB, and see what happens.

Ah yes I'm a bit confused, but I'm getting there slowly.

My big problem is to tame the sites/default dir to write mode. I changed db name etc. in the local "setting.php" file, then uploaded it through ftp, and still Drupal says it can't connect to the DB where I first installed Drupal 6.1 because the settings.php files hasn't changed. :-(

Solution: edit settings.php locally and upload the sites dir from your DD.
---
Libres-Ailé(e)s (Association for Linux and libre software) (France, Cévennes)

---
http://librefan.eu.org/ Libre-Fan (Mozilla, GNU/Linux, le Libre [et les femmes?]), France

Another way

Posted by bomarmonk on September 20, 2008 at 6:23am

Big dump can work: http://www.ozerov.de/bigdump.php

This uploads the mysql with a server-side script.