By mrodgers on

Hi

I am using Drupal 5 and did a lot of work on my laptop and want to now want to upload that work onto a hosting provider. I have just installed Drupal over there.

How can I export my content (pages, blocks etc) and import them to the new site? I looked at the import/export module and that seems to only work for 4.7.

Any ideas?

Thanks,

⋅ Categories: Drupal 5.x

Comments

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented

You use the phpMyAdmin to export the database and then import it on the server. Now, be aware that this is the whole database - it will wipe out what's on the server, if anything.

Nancy W.
now running 5 sites on Drupal so far
Drupal Cookbook (for New Drupallers)
Adding Hidden Site Design Notes

NancyDru

mpare’s picture

mpare commented

I hate developing sites on the actual live site, I also would discourage anyone from doing it except for minor tweaks.

So you have your amazing site built but its stuck on your laptop... Now what?

Well if you just want to transfer your theme there is nothing to it, just copy your theme and make it active. But if your like me and develop your entire site and data you will need to transfer your data base.

Well power up phpMyAdmin select your current Database and then click export. The default settings are all you need usually, so select the check box that says something like export to file. Go ahead and export that file and save it some where. Now on your actual webhost we'll do just the opposite procedure. Got to phpMyAdmin, select your DB, but this time click import. (Note if you already have data in the db you will need to drop those tables first. This will result in data loss if your new data file does not contain everything. I do not have instructions for data mergers and partial backup/restores) Select the file you just exported and import it, again the default options usually work just fine. That takes care of your db, now to your actual files. I usually just do a complete copy, but in most cases you do not want to override your settings.php file. I believe drupal 5 automatically sets permissions on it so that you can't just replace it without a little extra work. Alternatively you could create archive files like a unix archive or .tar of your local host and unarchive it on your server. Most hosting companies have utilities to help you do this.

This is just one method! Maybe not the easiest, the best, etc... but it is one that has served me well.

Peace,
-mpare
www.paretech.com

Did you figure out how to do something? Did you find documentation on Drupal.org inadequate? Well now it's your turn. Document your Success!

mrodgers’s picture

mrodgers commented

Thanks very helpful

lex0r’s picture

lex0r commented

You could try http://drupal.org/project/importexportapi as well for more granular control over import/export.
Be careful on importing - if nodes with ids from import file already exist they will be replaced.

Simplicity is the ultimate sophistication

Simplicity is the ultimate sophistication

gearhead’s picture

gearhead commented

I'm trying this node at http://www.musclecarsociety.com since it is at 4.7.4 and the upgrade I just tried fried the site and my hosting companies backups will not restore. I need this tool so I don't have to export this database and so I can gramar and spell check all the nodes.

Gear Head