By mzabala on

I am doing a Civicspace/Drupal install for one of my clients who has chosen to host with Godaddy.com. Now, first of all, I am quite aware of the "LOCK TABLES" privelages issue which I've been told I can address with the information found here.

Now, I have developed quite a bit of content on my local development server and have installed Civicspace on Godaddy's hosting. The only problem is, it seems that when I use phpmyadmin, I have no place where I can import my .mysql files. I've done a database export on my end, and there's no "browse" function in the SQL tab. There is only a place to put specific sql queries (and just copying and pasting by database export doesn't work)

Now, regardless of whether or not I can restore my database backup, I would still need this functionality in order to run the .mysql files packaged with many of the modules, and godaddy doesn't have shell access.

Now, I don't think getting my client to switch hosts is going to happen, so has anyone here gotten mysql imports to work with their current stripped down version of phpmyadmin?

Sorry for posting here, but I got no helpful response from godaddy's technical support. The guy I talked to said he was unfamiliar with this sinec it was the first time he had to deal with this issue... you'd think that import mysql statements or restoring backups would be common enough.

⋅ Categories: Drupal 4.6.x

Comments

heine’s picture

heine commented

Some versions of phpmyadmin provide an 'import' tab after selecting a database, where you can give the filename. The SQL button (small, not the tab) also contains an 'import files' tab sometimes.

I'm curious; how will you solve the LOCK TABLE problem?

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

mzabala’s picture

mzabala commented

Supposedly the fix is here

http://drupal.org/node/1190

But I have yet to actually implement it since I am trying to resolve this database issue first.

It seems like the version of phpMyAdmin on Godaddy lacks the "import files" tab that I'm used to seeing on every other host. I thought that function came standard. Doesn't it? I mean, without shell access, how else can one import?

nevets’s picture

nevets commented

I recently set up a sight for someone using godaddy and after logging into phpMyAdmin I select the database I want to work with and then one of the tabs at the top reads 'SQL'.

I click the tab and lower half of the form (starting with 'Or Location of the text file:') allows me to import a mysql file.

mzabala’s picture

mzabala commented

I was in the SQL tab and all I got was this screen

Click for screenshot

Am I missing something here? I couldn't find anything in their helpfiles or the drupal forums about people being unable to import mysql, and I'm beginning to wonder whether my phpmyadmin is working differently than those of other people on godaddy.

Thanks for your help!

scandiman’s picture

scandiman commented

I had this same problem and this tip works for the phpmyadmin in the mysql controls at 1and1.com also. Thanks!

PakWaan’s picture

PakWaan commented

I tried hosting with GoDaddy last night (and since dropped them and went to Site5 because of the lock tables issue, which everything I've read here says you CAN'T deal with) ( see http://drupal.org/node/17241 )

But at any rate - I did manage to get the database set up first. Since they don't have a browse button on their crippled version of MyPHPAdmin, you merely need to open up the "database.mysql" file with a decent text program and cut and paste the entire contents into the SQL box then hit OK. (notepad didn't do it for me - lost the formatting- but Notepad++ works great, and is one of the best free html editors around)

mzabala’s picture

mzabala commented

I tried that and it gave me a bunch of syntax errors I shouldn't be getting from a straight export.

I'm thinking that the solution might be to get my client off godaddy, but I have a feeling that future clients will still come to me with their hosting on Godaddy and I'd still like to know how to resolve this.

PakWaan’s picture

PakWaan commented

It gave me a bunch of syntax errors also when I did it from Notepad - but I deleted the database, started over and once I copied it with the proper formatting, it worked like a charm.

EclecticGuy’s picture

EclecticGuy commented

I know this is dated, but I thought I would post anyway in case someone stumbled across this page (as I did) looking desperately for an answer. I almost changed hosting because of this issue. Telephone support was useless - they could not help me. Email support is what saved me. Here is how you import a backup .sql file (make sure the data base you are importing to is clear of the tables you are trying to import or you'll get an error message, I had to drop all the tables Joomla created in my new data base before I could import my backup Joomla .sql file).

To import a .SQL file into a MySQL database:

• Log in to your Account Manager.
• Select Web Hosting & Databases from the Hosting & Email menu at the top of the page.
• Click the Open link under the Control panel heading for the hosting account which holds your database.
• Click Databases.
• Click MySQL.
• Click the Open Manager button.
• Enter your username and password for your database.
• Click on the database into which you are importing data.
• On the far upper-left corner of the page, click on the SQL button [these buttons are tiny]. This will be immediately to the right of the green Exit button.
• In the new window that appears, click on the Import files tab.
• Click on Browse and browse to where you have your .SQL file located on your machine.
• Once you have found it click on Go.
• This will run the SQL file and update the database as specified in that file.

elh’s picture

elh commented

I am trying to import a text file to godaddy but cannot get it. it is a csv file and comma delimiter. it says it imported successfully. but doesn't show the table.

Any help would be appreciated!
thansk

elh’s picture

elh commented

I use Navicat as a user interface for Mysql. But I cannot set up the database that I have on godaddy into Navicat. Any idea?

tree2009’s picture

tree2009 commented

how to import large mysql file in Godaddy, click the link to have a look
http://psdtucss.com/?p=1