Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: A little help on moving a flat file

    Greetings and salutations, just found the site and am really enjoying reading the posts. I however did not find anything that related to an issue and would like to seek some advice from you all.

    Currently I have a flat file that resides on one server that I need to export to a new server and place it into a new database that is ready to go. I know there is the load feature, but not sure if this would work. Would I be able to point the database directly to the flat file by using the IP address and directory it resides in?

    Any advice is greatly appreciated.


  2. #2
    Join Date
    Jan 2004
    Depends on what format the flat file is in. If it's in a comma delimited file/CSV it would take about 2 seconds to convert it using something simple like PHPMyAdmin. If you want to do it by hand it takes a little more time.

    But that is the biggest thing is knowing what format the current version is in. And you would actually need to copy/scp the file from one server to the new server or unless you have it locally you can use PHPMyAdmin.


Posting Permissions

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