By harryc on

If you use a web-based control panel, you should be able
to upload the file 'database.mysql' from Drupal's 'database'
directory and run it directly as SQL commands.
My control panel is on godaddy and I have no idea how to connect mysql database with database.mysql.
thanks for listening,
Harryc

⋅ Categories: Drupal 4.6.x

Comments

heine’s picture

heine commented

Does the GoDaddy control panel (CPanel / Plesk / ?) give you access to a webbased interface to MySQL, such as phpmyadmin? Instructions for phpmyadmin can be found in the cPanel and Plesk guides.

--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

harryc’s picture

harryc commented

thanks for your help, Heine.
1. Open phpMyAdmin (there is a link in the button of the cpanel MySQL account maintenance screen).
2. Select the newly created database. Done
3. Open the SQL tab. Either connects to mysql homepage manual or to an input panel that asks: Create new table on harrydrupal (my database) Number of fields:
4. Extract database.sql into a file on your LOCAL machine.
5. Run the SQL script needed to create the drupal tables by uploading the file from your local machine. Should I enter the location of the file database.mysql in #3 above?
Thanks!

heine’s picture

heine commented

Yes, its should be database/database.mysql in the drupal archive.
I'll take a look at the CPanel page and update it.

edit: the page needs a big rewrite, will happen* later. For now: don't forget to adapt $base_url in settings.php too!

Heine
--
* Yes yes, I'll do it

harryc’s picture

harryc commented

I imputted the file address. Now it wants me to enter the Number of fields: What number should I imput?

For now: don't forget to adapt $base_url in settings.php too! Are you talking about the statement that indentifies the database with user name and password?

Thanks for you help, Heine.
Harry

heine’s picture

heine commented

I now see what you are doing. Can you recreate the database or undo your changes?

The tab SQL should give you a field that allows you to upload and execute an SQL file, in this case database.mysql.

From the plesk page, although this apparantly depends on the phpmyadmin version used.:

First make sure the relevant database is selected. If necessary, click Databases in the phpmyadmin start screen and then the database name.

Go to the SQL screen via a small button labelled SQL in the left pane of the phpmyadmin screen.
Select (the tab) import files. Upload the file database/database.mysql with the database scheme.

--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

harryc’s picture

harryc commented

You are a genius. Are you like, "on duty," to answer questions from dummies like me? If so, thank you very much.
For your information, the SQL tab at GoDaddy allows you to "import" a file. Whatever. I did it and got the login screen at my site.
Thanks again,
Harry