Basic Drupal database export question
AngelicLight - December 4, 2008 - 14:26
Hi, there,
I'm just getting ready to go live for the first time, and I noticed that my host-provided MySQL database name appends my hosting user name to the front of the database. Is this going to be a problem? Do the database names have to be identical that you're exporting from and importing to?
Along those lines, does the database username and password have to be the same?
Haven't used MySQL before outside of Drupal, so I apologize in advance if this is obvious...
Thank you very much,
- A
The database name, username
The database name, username and password do not need to be identical. You can easily change those settings by editing the settings.php file in the /sites/default folder.
Thank you very much. Should
Thank you very much.
Should I change them to match before I do any sort of export just to ensure smoothness or do things just not get out of whack that easily?
And thanks again.
You can change settings.php
You can change settings.php at any time, it will not affect your database. Settings.php is the link between your database and your php scripts. If the settings are correct, everything works. If not, nothing happens: nothing good, nothing bad, just nothing (except the error message that Drupal could not connect to your database).
Thanks a lot, Marc - have a
Thanks a lot, Marc - have a good day!