1. Home
  2. Community
  3. General Questions
  4. Moving entire site to a new machine

This website can use cookies to improve the user experience

This website can use cookies to improve the user experience and to provide certain services and functions to users. Cookies contain small amounts of information (such as login information and user preferences) and will be stored on your device.

Enable All Cookies Privacy Policy

Moving entire site to a new machine

General Questions 916 This topic was started by ,


avatar
Rushian 0
From: -
Moving entire site to a new machine

I am currently self-hosted on a Windows box.

The hardware is almost 5 years old (running WinNT and IIS4 no less) Smiling Face, and really starting to show its age, so I will be building a new machine to run the website.

How do I move the databases to the new machine? Is it as easy as copying all the storyteller databases from my /mysql/data/ folder to the new machine? (Assuming the db username and passwords are set up the same on the new machine?)

Is there a better or more sophisticated way of doing it?

Thanks,
-Rushian

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic

1 Re: Moving entire site to a new machine
avatar
OP 0
From: -
Moving entire site to a new machine

Ok, great! Thanks!
1 Re: Moving entire site to a new machine
avatar
Administrator
1342
From: Austria
Moving entire site to a new machine

I would dump the database to a SQL file:
mysqldump -uusername -ppassword database > database.sql

You need to replace username with your MySQL username, password with your MySQL password, and database with the database name.

Then import the SQL file on the new machine:
mysql -uusername -ppassword database < database.sql

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.