Move database to new server?

[Yonkey]

SMF Version: SMF 1.1 RC2
Hello,

I would like to move my forum database to a separate server, but leave the files on the existing one.  How is this possible?  I tried entering in the IP for the MySQL Server in repair_settings.php but it keeps saying:  Some settings are not being shown because the MySQL connection information is incorrect.

[Oldiesmann]

Make sure that all the MySQL server information is correct and that the server that you're moving things to accepts external connections.

[Yonkey]

What exactly is the "MySQL server" field?  It's usually localhost, so I'm assuming it will be the IP address of the new server?  I haven't found any examples anywhere of people using anything other than localhost so I'm not sure...

Also, how can I verify that the second server accepts external connections?

[青山 素子]

You'll have to ask the people running the server if you can contact it from the webserver. They can also provide you with the information you need to enter to connect.

[Yonkey]

Actually, I'm running the server.   Well, not literally but it's a Virtual Private Server and I'm actually the one who installed mysql on it.  I would greatly appreciate it if anyone can tell me where to find the server connection settings, as I already know the login, password and database.

Thanks!

Oh and to answer your question, I can access it via that server's phpMyAdmin, as well as its Webmin web interface.

[青山 素子]

If it is listening on an outside interface, you should be able to use the IP or a DNS name as the mysql server in the SMF settings. Just make sure you grant access to the username you are using and check password is fine.

[Yonkey]

The username and password I verified quite a lot, but it's the IP i'm not sure of.  So how would I enter it, just numerically like: 127.0.0.1 or with the URI: http://127.0.0.1/

(and yes, I know that's not a real ip address, it's just an example )

Thanks

[青山 素子]

Just numerically.

And it is a real IP address.

Koodi [Valitse] Laajenna


;; QUESTION SECTION:
;1.0.0.127.in-addr.arpa.                IN      PTR

;; ANSWER SECTION:
1.0.0.127.in-addr.arpa. 86400   IN      PTR     localhost.

;; AUTHORITY SECTION:
0.0.127.in-addr.arpa.   86400   IN      NS      localhost.


[Yonkey]

Yes, I know it's localhost, but I guess you didn't get the joke or the irony.   This whole thread is because I've only seen SMF work on "localhost" and no other IP.


EDIT: Grammar.

[Yonkey]

Numeric doesn't work:

Some settings are not being shown because the MySQL connection information is incorrect.

[青山 素子]

Odd. Are you using some weird private IP? Are you using a public IP? Also, try assigning a DNS name and using that.

[青山 素子]

Yes, I know it's localhost, but I guess you didn't get the joke or the irony.   This whole thread is because I've only see SMF work on "localhost" and no other IP.

I like killing jokes with logic. It is fun.

[Yonkey]

Odd. Are you using some weird private IP? Are you using a public IP? Also, try assigning a DNS name and using that.

I doubt it's private considering you can access it via the web: http://69.12.216.149/

How would I assign a DNS name to it?

[Yonkey]

Ok, I assigned a DNS name to it: http://www.silverliningthegame.com/ but SMF still can't read it.

Does anyone else have a suggestion?

[青山 素子]

That name (and the IP) takes me to the apache placeholder page. Are your forums somewhere else off the root?

[Yonkey]

Ok I actually found the problem.  I had to grant mysql privileges to the other host trying to access the database.

[青山 素子]

Haha. I've gotten bit by that before too. Easy thing to overlook.

[Yonkey]

Yeah... I actually should have just made a test connection script to begin with.  The SQL error was pretty self-explanatory (compared to the vague one in repair_settings.php).   Oh well.