Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New Coder
    Join Date
    Jul 2011
    Location
    Sunshine State
    Posts
    80
    Thanks
    18
    Thanked 0 Times in 0 Posts

    phpMyAdmin - HUGE import

    Hi gang

    I have a db that I'm trying to get imported into phpmyadmin. The site is hosted on godaddy so there is a limitation of 1024k for importing - yeah not really going to work with a 14 meg db

    I have the complete .sql file and what I would like to know is what is going to be the easiest way to get this data back into the db?

    any help is greatly appreciated

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    do you have FTP access to the host? If so FTP the file in place.
    then in phpmyadmin choose the SQL tab. You can write any type of query there.

    So type in:
    SOURCE /pathtoyourfile/yourfilename

    and then click GO.

    Unless they have some kind of restriction in place it should run your file.

  • #3
    New Coder
    Join Date
    Jul 2011
    Location
    Sunshine State
    Posts
    80
    Thanks
    18
    Thanked 0 Times in 0 Posts
    thanks for that guelphdad...

    I've tried several combinations and each time received
    Code:
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'f3m2012.sql' at line 1
    unless I'm doing it wrong? I used http://www.domain.com/directory/file.sql - with and without http

    been a very long week and this is only Tuesday so bear with me if I'm being dumb

  • #4
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    Okay you've FTPd your document to your computer and it is in a directory that mysql has access too?

    you just want:
    Code:
    SOURCE /directory/file.sql
    and you'd want that from the SQL tab itself.

    is your file an actual mysqldump or is it just tab separated data? if the latter you'd want to do the import differently of course but it sounds like a dump of the create table statements and acutal INSERTS that a mysqldump would create.

  • #5
    New Coder
    Join Date
    Jul 2011
    Location
    Sunshine State
    Posts
    80
    Thanks
    18
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by guelphdad View Post
    Okay you've FTPd your document to your computer and it is in a directory that mysql has access too?
    I don't know how to answer that question (wow now I really do feel dumb) - I do know that if I want to use a php connect function I wouldn't use localhost for the db host - godaddy has xx.hostedresource.com for the db host - is that what you mean?

    it's a dump with all the create/insert stuff - that I DO know

  • #6
    Master Coder felgall's Avatar
    Join Date
    Sep 2005
    Location
    Sydney, Australia
    Posts
    6,627
    Thanks
    0
    Thanked 646 Times in 636 Posts
    Quote Originally Posted by dnnhater View Post
    it's a dump with all the create/insert stuff - that I DO know

    How was the file created? If you are getting a syntax error then there is something in the file that isn't being recognised properly as an SQL statement.
    Stephen
    Learn Modern JavaScript - http://javascriptexample.net/
    Helping others to solve their computer problem at http://www.felgall.com/

    Don't forget to start your JavaScript code with "use strict"; which makes it easier to find errors in your code.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •