Alpha Video Training
Results 1 to 6 of 6

Thread: Any method to backup data only?

  1. #1
    Member
    Real Name
    Victor
    Join Date
    Dec 2004
    Posts
    43

    Default Any method to backup data only?

    I know there is a option in A5 to backup only the data file.

    But I'm now having a problem like this..
    I've made some changes to the table, say increasing a numeric field from 5 to 10 digits.

    How can I get my old data fit into the new table?

    Restoring the backup which say it keeps the data files only would also cover the new table structure.

    Once I tried to copy only the .ddbf file into the modified app, the data become symbols.

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,308

    Default RE: Any method to backup data only?

    Are you saying you made a backup, you then changed the table structure, and now you want to "restore" to the new structure records from the old backup? If so I don't think this is going to be easy to do safely. A backup AFTER the restructuring would of course have made this a snap.

    Perhaps others will have better ideas for you but first ideas here are:

    1) Do the restore, then restructure the table all over again.

    2) Export the records in the backup table to CSV formatted text file, and then import them into the new structure.

    In any case it would be prudent (essential) to make good backup copies of your current application, including the data, before attempting either approach.

    -- tom

  3. #3
    Member David Brown's Avatar
    Real Name
    David Brown
    Join Date
    Sep 2003
    Location
    Miami, FL
    Posts
    133

    Default RE: Any method to backup data only?

    If you rename your new table, for instance instead of table1 name it table1_new. Then add the old table1 to the database. You can then do an append operation to append the data from table1 to table1_new. Then delete table1(which is the old structure) and rename table1_new to table1.

    -Dave

  4. #4
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,308

    Default RE: Any method to backup data only?

    Victor,

    On re-reading your initial post I think I see your question in a different light. If you're asking whether there's a way to backup only the data without the data files themselves, the answer is no. If you wanted to separate the data from the files that contain the data you should EXPORT the data to a different format.

    -- tom

  5. #5
    Member
    Real Name
    Victor
    Join Date
    Dec 2004
    Posts
    43

    Default RE: Any method to backup data only?

    thanks for your reply, I think of the opposite way :)

    I rename the old dbf file and add it to my new app.

    Using the append function , I append the old records to my new table, after that I remove the old table.

    it works~!

  6. #6
    Member
    Real Name
    Victor
    Join Date
    Dec 2004
    Posts
    43

    Default RE: Any method to backup data only?

    the export and import function is hard to get it work in my way...

    seems they are buggy..

Similar Threads

  1. Combining live A5 and A4 data, best method?
    By Robin Sculthorpe in forum Alpha Five Version 5
    Replies: 3
    Last Post: 12-09-2004, 04:15 AM
  2. incorrect data type, method not found errors
    By W. Horton in forum Alpha Five Version 4
    Replies: 3
    Last Post: 10-29-2002, 04:49 PM
  3. backup of alpha data
    By Mitch Mccoic in forum Announcements
    Replies: 1
    Last Post: 12-19-2001, 09:35 AM
  4. data files to backup
    By Jeremy Packman in forum Alpha Five Version 4
    Replies: 1
    Last Post: 04-30-2001, 03:51 PM
  5. Is there an easy data backup?
    By Walter Jewell in forum Alpha Five Version 4
    Replies: 8
    Last Post: 10-05-2000, 11:04 AM

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
  •