Page 1 of 3 123 LastLast
Results 1 to 10 of 25
  1. #1
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Having problems transferring MySql

    I am trying to update to v151 from 1.3.9h. I have a freshly installed version with no changes made and I am trying to transfer MySql before doing anything else and when I go to Import I get this message... "The directory you set for upload work cannot be reached". I know I'm doing something wrong but I have no idea what. Please help!

  2. #2
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Having problems transferring MySql

    I should have said that I have a freshly installed version in a new folder and that my old site still remains

  3. #3
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Having problems transferring MySql

    Quote Originally Posted by doooomed View Post
    when I go to Import I get this message... "The directory you set for upload work cannot be reached".
    Is that an error message inside phpMyAdmin? If so, then contact your hosting company for help with it, since phpMyAdmin is hosted by them, and not connected to Zen Cart.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  4. #4
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Having problems transferring MySql

    Thank you Doc, I am just awaiting a reply from them. I should also mention, just in case it means something to you that when I am on the page to Import mysql I also have the option to upload directly from my computer, which I did, and it claims to be successful but no changes are made to the site. Maybe I forgot to do something?

  5. #5
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: Having problems transferring MySql

    Are you aware of how to handle the MySQL "file"?

    Essentially, it is little more than a mass of "organised text".

    Technically, a SQL "dump" can be stored as a plain TXT file. I give my backups the file extension .sql so that my editor recognises it. But I could call it "xxxxxx.txt" and it will retain all of its integrity.

    But as I said... it's little more than a wad of "organised text".

    The only way the "file" will operate, is if it is IMPORTED IN TO A MySQL DATABASE.

    Only AFTER it is put into a MySQL database, will it operate as intended.

    It looks like you have done step ONE (capture the CONTENT of your original database).

    Now step TWO will be to IMPORT it into a MySQL database...

    It can't just hang around as a "file"... it needs to be inside a database.
    19 years a Zencart User

  6. #6
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Having problems transferring MySql

    Hi Schoolboy, I understand what you are saying. I am not sure if I am going about putting the information into MySQL database properly. I think I am but it's not working so probably not. This is my understanding... saved the old db to my desktop, installed the new store into a new folder. I named the new MySQL the same as the old (same login info, same everything) and I thought that would work. Then I tried the export/import method with no luck. I'm pretty sure it's me doing something wrong but I'm pretty lost at the moment as this is the first time I've done this.

  7. #7
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: Having problems transferring MySql

    Much will depend on how you made the "backup" or "copy" from the ORIGINAL database.

    You may have saved it as a ZIP file or something.

    Tell me what your database "file" is called?

    Is it something like " XXXXXXXX.sql "

    What file extension does it have? (.sql ... or .txt .... or something else ???)
    19 years a Zencart User

  8. #8
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Having problems transferring MySql

    *********_zc1.sql

  9. #9
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: Having problems transferring MySql

    How "confident" are you with working in phpMyAdmin ???

    There is another way to do this WITHOUT having to manually copy the database.

    In phpMyAdmin, you can get the system to copy a database for you (if you are working off the same location).
    19 years a Zencart User

  10. #10
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Having problems transferring MySql

    Not much knowledge in that department but as long as it won't bother my active site I'd be willing to try!

 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. v150 Problems transferring databases
    By digipete in forum Upgrading to 1.5.x
    Replies: 1
    Last Post: 27 Jul 2012, 07:34 AM
  2. Problems Transferring Zencart to New Website
    By brianj_hill in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 30 Apr 2010, 06:10 PM
  3. Problems with manually upgrading MySQL 4 to MySQL 5
    By 2004g35 in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 29 Oct 2009, 02:15 AM
  4. Transferring a non-mySQL database
    By flickfan51 in forum General Questions
    Replies: 1
    Last Post: 26 Jul 2007, 05:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR