Dabase cannot upload on MyPHP

  • Hi there,

    So, my wordpress was backedup and saved, database included, before I moved hosting services within the same GoDaddy account, to consolidate under a delux service. I have no problems migrating a general .html site and for the most part I was able to move my wordpress blog and all of its files over. My problem now is restoring MySQL datbase with MyPhP on Go Daddy.

    The first problem is that it won’t accept a .gz zip or a general .zip file. I keep seeing references to being able to change this somehow but while I am fairly well versed in being able to Google myself out of situations in coding, this seems a bit beyond my expertise. I have no idea where to find some of these php.ini files to modify so it can accept a .zip file.

    The second problem is if I try to upload the db backup unzipped I am running into an error message after it tries the first upload. I realize that these things can time out and was reloading and letting it upload from the last place it left off but after the second upload I am getting this error:

    SQL query: /’140103 SET TIME_ZONE=@OLD_TIME_ZONE’/ :

    MySQL said:
    #1231 – Variable ‘time_zone’ can’t be set to the value of ‘NULL’

    In my Googling I found this error and various people had some workarounds, (a) one being that this is a common error because of the broken up uploads and I could separate out the tables and upload separately and (b) changing the code in the text of the db to fix the error.

    for b: I tried changing the code but the upload threw another error and didn’t like that I changed anything. For a: I tried cutting and pasting segments of the code into next .txt files but again, doesn’t like this.

    I also found an option for a .php code for a DUMP proram, which started working but then it threw an error at me stating I needed to Drop tables. I see the use of Drop witin my DB txt in some areas but have no idea how to really go about dropping tables to get this Dump program to work.

    So, what I’m saying, this is kind of beyond my website and coding abilities and I need some help.

    How the heck do I change the database uploading program so that it will accept a .zip file or .gz file so that I can upload and restore my database or b: what other program can I use.

    Or am I just going to have to cave and get my programmer BIL to help?

    Thanks and I hope this makes sense!

Viewing 4 replies - 1 through 4 (of 4 total)

  • I have done this numerous times on various GD accounts and have never had an issue by just exporting the db using phpMyAdmin and the default export settings, that is:

    – start phpMyAdmin
    – select database from the left side panel
    – click the Export tab
    – Export Method: Quick – display only the minimal options
    – Format: SQL
    – click GO
    – the .sql file starts downloading

    At the new hosting account:

    – create a new database
    – start phpMyAdmin
    – select the new db from the left side bar
    – click the Import tab
    – File to import: click
    Choose file, navigate the downloaded .sql file, select it, click Open
    – leave all other options as-is
    – click Go
    – as long as your exported .sql file is under the Max file size indicated in the File to import section, the db will import in ” a bit” ??

    The only time I have had an issue is moving a site with a very large exported file. I have never had success using any of the compression methods, so I just set up the new db to accept remote connections and then use NaviCat for MySQL to do the job. This has successfully worked for db exports exceeding 2GB (eFront LMS sites).

    Cheers!
    Lyle

    Dion

    (@diondesigns)

    At the new hosting account:

    – create a new database
    – start phpMyAdmin

    Based on the errors that were listed, I’d be willing to bet that your step #1 was not done. ??

    If one has access to SSH, databases can be imported by directly accessing the mysql server. This method has no limitations on execution time or file size, and files can be in any compressed format supported by the operating system, but it does require some familiarity of command-line operations.

    Thread Starter mistiaggie

    (@mistiaggie)

    Yes, a new database was created.

    Thanks for the other software recs but I don’t know them and will have to research them to even figure out how to work them.

    It doesn’t seem like this is a simple fix.

    ??

    Dion

    (@diondesigns)

    Many large hosting companies, GoDaddy included, provide severely crippled versions of phpMyAdmin to “protect” their clients. Actually they do it to minimize support questions.

    You might want to consider downloading a “real” version of phpMyAdmin from phpmyadmin.net and temporarily installing that on your site. Once you complete the import, you should delete the installation because it’s dangerous to have that program in open view of potential hackers.

    Also, yYou might get more responses if you posted this in a different forum. This forum is for localhost installs. Your problem concerns a hosted installation.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Dabase cannot upload on MyPHP’ is closed to new replies.