Results 1 to 10 of 3833

Threaded View

  1. #9
    Join Date
    Feb 2007
    Location
    Burleson. Texas
    Posts
    194
    Plugin Contributions
    0

    Default Re: Uploading to database via SSH

    Quote Originally Posted by maxim View Post
    Greetings all,

    I have large files to import, which I was previously able to upload via splitting the file. Recently, the server on my host - hostgator - hasn't been allowing me to split or upload files properly. The host gave me SSH access - mind you, I'm a newbie here - to do the upload. (I'm using putty for SSH.)

    Here are my questions:

    1) I noticed in tutorials on SSH that the file name ends in ".sql". Should I use that extension or use the ".txt" extension on my file?

    2) The host recommended that I not split the file. Do I need to change anything on the Easy Populate configuration since I'm not splitting the file?

    Any and all advice is appreciated. I may not be able to reply to responses right away...the toddler might need its momma.

    Thanks a bunch.

    Newbie Linda
    Hi Linda,

    Please use this at you own descretion, as I never used SSH, but if it is in sql format, it would probably need to be socked straight into the database (not uploaded via EP). There is a MySQL Patch in the tools section that allows for sql inserts. Backup your database, make a 1 product file and try inserting it there (just copy/paste the file there). If it works, great, if not, you will get a host of error messages and hopefully no ill effects. Push come to shove, just restore that backup you did a few minutes before, no harm, no foul. PS, I backup before any EP upload, just in case. It would be prudent to do so if using SSH also.
    Last edited by awhfy99; 5 Jun 2008 at 07:53 AM.
    Dennis
    www.stampdays.com
    Over 80,000 stamps and still growing!

 

 

Similar Threads

  1. v150 Easy Populate 4 vs. Easy Populate CSV - What's going on with so many Easy Populates?
    By oleancomputers in forum All Other Contributions/Addons
    Replies: 4
    Last Post: 20 Jun 2013, 05:58 PM
  2. v151 Difference between easy populate and Excel Populate
    By Kevin205 in forum General Questions
    Replies: 7
    Last Post: 22 Jan 2013, 04:33 AM
  3. v139h Easy Populate Free vs. Easy Populate Paid
    By fabienne in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 22 Apr 2012, 02:37 PM
  4. Easy Populate support for Version 1.2.5.4 issue
    By txcharms in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 26 May 2010, 07:35 PM
  5. Easy Populate From osc vs. Easy Populate Free - from langer / modhole
    By relix in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 24 Oct 2009, 04:38 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