0 specification with a considerable number of additions and a couple of exclusions. Heck, even with a local import (imp file=local. A parameter file is a text file listing the parameters for Oracle 12c's Data Pump Export or Import and setting the chosen values. Append Date & time to File name in Window Batch file Sometimes it may be required to schedule the same task twice a days. How to import and export a PostgreSQL database. While this isn’t a reversible transformation, it makes it easier to dump SQL NULL data values to CSV files without preprocessing the data returned from a cursor. >> In order to import when going down a version use the lower version's export utility. This article describes how to use personal storage folders, also known as. The SQL Server Import and Export Wizard is based in SQL Server Integration Services (SSIS). Instead, compress the files into one smaller, easier-to-manage file. A dump file can be a mini-dump file or a full dump file. I have to import a 9GB dump file produced by expdp. In the next article, we will explore the use of Python for importing ZIP file data into SQL Server. I'm planning to compress the Oracle export dump files of all Oracle database servers to reduce space usage on their disks. 1 AWS RDS database along with changing the schema name to "EPS. Exporting data directly to a compressed file. Oracle newbie may also find it is very easy to Export/Import data objects with this tool even without typing an Export/Import parameter. Tips on exporting your Oracle Apps reports to Excel Introduction Oracle E-Business Suite provides users with a host of standard reports. Use the following command: To encrypt the file to a compressed file in Linux operating. How to Import All Databases into MySQL. In the next article, we will explore the use of Python for importing ZIP file data into SQL Server. Don't use any ' or other special characters for file name. I have an internal customer that does oracle backups and then uses gzip to compress them. So, I had to find a way to use IMG file in VirtualBox. Export/Import is still available, but Data Pump has taken the tasks traditionally done by Export/Import and added a lot more options and flexibility. Data Pump (expdp, impdp) Enhancements in Oracle Database 11g Release 1. This is the default for file-based imports. Clear answers are provided with tutorial exercises on saving data as flat files, loading data from flat, exporting and importing database, schema. How to Copy files from ASM to filesystem and filesystem to ASM Oracle DBA Interview Questions and Answers - Dataguard Oracle DBA Interview Questions and Answers - ASM. Now let's see how you can avoid/prevent using each feature that is part of ACO. One way is to use original. Unlike operating system or file system compression utilities, Data Pump compression is fully inline on the import side as well, so there is no need to decompress a dump file before importing it. How do you import a dump file from a Linux-based Oracle database into a Windows-based database? Can this also be done with compressed and split chunks? The dump file from an Oracle export is platform independent. 1877818-How to export/import oracle DMP file into your Oracle database? Symptom. exe utility to generate a dump file on demand for any Microsoft Windows application. NOTE - For using compression parameter with datapump, we need to have Oracle advance compression license. It is of course possible that it is not proper Oracle dump file after all. Best Regards. How can I import a large. The dump file set consists of one or more disk files that store table data, database object metadata, and control information. It is possible to peek into the datafiles and see what data they contain. The dump file size was reduced by 74. zip Archive Without Being Extracting. Few OSs also not supported the big size of the single file so we have to split the backup file into different files or we can go with compressed options. I am impressed with the compression algorithm because in the event of an import operation (impdp), Oracle decompresses automatically (No additional options required). For the life of me, I cannot get it to import the data. Dump your local database in compressed format using the open source pg_dump tool: $ PGPASSWORD=mypassword pg_dump -Fc --no-acl --no-owner -h localhost -U myuser mydb > mydb. Data Pump offers compression of the data before pushing it to the dump file. dmp ? On: Thursday, February 13, 2014 By How to use import database in oracle using imp utility ? 1. Import the database dump file (export. We can compress the dumped data by using gzip or similar compression tools. Now let’s import the data. exe and the. Create the target user first. In an Oracle database you can do it using the import command. Otherwise, it doesn't work well in new Oracle database version (11g). Had and old export dump file I wanted to import into RDS. In my first blogpost about this I told about batch data loading from generic Linux (or even Unix) servers, Today I'm going to explain some best practices about data movement (offloading) from the Oracle Database to the HDFS in batch mode. Create dump file. Java Compress File. To begin, you will need to create an Oracle directory to export the file to and then grant read and write on the directory for the schema. I' working with new project VS. Each thread generates output in its own file, so the result of the parallel export job is a set of files. It is a package that contains files used to describe a virtual machine, which includes an. We don't use Oracle or have any in-house Oracle expertise. 1 to version 4. dmp file and use rdsadmin. ORA-39143: dump file "C:\oracle\ggexp. Dump your local database in compressed format using the open source pg_dump tool: $ PGPASSWORD=mypassword pg_dump -Fc --no-acl --no-owner -h localhost -U myuser mydb > mydb. Most of the times, we would have the export dump file in hand. On the Import SVN Dump File page, click Browse. I've installed Oracle 10g and now i need to restore the original database. 7)Sequential media, such as tapes and pipes, are not supported in oracle data pump. The resulting repository will be about 15GB. I work on oracle 10g and devsuite 9i forms and reports on linux environment. Table SOFFCONT1 contains SAP Business Workplace/SAPoffice objects which often grow rapidly in Netweaver based component. 12c and export/import from a lower version. increase the space in the zpool by enlarging a vdev or adding a vdev 6. Active 10 years, 1 month ago. ORA-39000, ORA-39143 ORA- 31619 invalid dump file in datapump Today i am tired to export one schema (hr) from the one database into another database ( import schema ) so i created one directory which is called "ram". Import Data Pump compatibility: 1. database_dump. Like any other Perl Module Ora2Pg can be installed with the following commands:. The following are code examples for showing how to use joblib. Use zip or gzip to compress the dump file for easier FTP and/or mailing; Write the contents of the log file into the body of an email. imp yasas/yasas file=mydbdump. Valid keyword values are:…. Importing oracle procedures may be hard i suppose, i'm not sure if oracle and postgres have the same syntax. 46 BR0656I Choice menu 1 - please make a selection ——————————————————————————- BR*Tools main menu 1 = Instance management 2 - Space. Note how we used some of the best practices for loading data. You either have to use a) SSIS: SQL server integration services b) Create a linked server in SQL Server to ORACLE. From the file dialog, go to the file with either the. N can usually be found in /var/crash/`uname -n`(run the dumpadm command to see if that’s where you are directing your crash dumps). It's obvious when you know it, but if you made your file on a windows platform, use '\r\n', otherwise use '\n'. In this case, either remove the statement manually before replaying the dump file, or output the dump file without the statement. gz extension. Export/Import - Data Pump interviews questions and answwer- 1 in oracle November 19, 2016. 2) altered the format of the help output as well as adding the following parameters. Compress tables during import Oracle Database 12C release 1 (12. I first tried to use S3 as a hosting site for the. I saw lots of articles showing how you can import the dump file back to mySQL when the dump file is. This is where the contents of the dump file will be imported. Upgrade Oracle Database 11g to 12c. download_from_s3 to copy the file to the RDS database then import it with DBMS_DATAPUMP. Before performing the import you must know the directory object of the directory where dump-files are located also the names of dump-files from which you will import the tables. If we need to do dump multiple times in a day the disk will be full. Hi Amit, I received 4 dump files for a client database that he exported on same file share directory. Next, we import from dump file to Schema you have just created. 20 (31) BR0280I BRTOOLS time stamp: 2015-05-12 03. expdp and impdp with gzip tips Oracle Database Tips by Donald BurlesonDecember 20, 2015 Question: I want to be able to zip and unzip amy dmp file file and I want to import data with impdp from file_name. Compressing files in modern operating systems is usually pretty simple, but things can get more complex when the files are large. During an export operation, data is first compressed and then encrypted before being written to the dump file set. At the target database the Import tool will copy the data from dump file to the target database. The Data Pump Import utility comes with the Oracle Installation by default. 6) Consider COMPRESSION option to reduce the export dump file sizes Oracle 11g introduced the concept of compressing contents in the export dump file. In addition to basic import and export functionality data pump provides a PL/SQL API and support for external tables. How To Import One Table Back from a Dump File? - A collection of 27 FAQs on Oracle loading data and exporting data. Use the zipinfo command to view a list of files in the. First, log in to the database as root or another user with sufficient privileges to create new databases: mysql -u root-p This will bring you into the MySQL shell. The dump file size was reduced by 74. Importing CSV files gets a bit complicated when you start doing things like importing files with description fields that can contain punctuation (such as commas or single-double quotation marks). 1) Nowadays we generally have two tools for data movement from the Oracle Database – Sqoop and Copy2Hadoop 2) For performance considerations it make sense to use only Oraoop version of Sqoop (link) 3) In my configuration (Exadata x5-2 QR and Big Data Appliance Starter Rack) Sqoop was faster for simple import, when we moved all table. Hi All, I have a full oracle dump file that I have exported from a production server. GitHub Gist: instantly share code, notes, and snippets. Your “OLE DB Source” is the Oracle database, so double click it and assign. Rman Configuration Parameter Part-2; (Descending and Key compressed) index - Oracle11g Find unused index in Oracle 11g Oracle 11g Index Introduction Of Backup And Recovery Logical Backup *DUMPFILE - List of dump files to import from [expdat. Use the following command: To encrypt the file to a compressed file in Linux operating. The compressed dump file is about 2G. 7, it is not recommended to load a dump file when GTIDs are enabled on the server ( gtid_mode=ON ), if your dump file includes system tables. To export the data from Oracle using the command line. AWS RDS Oracle database support datadump as a mean to export/import data. Active 4 months ago. Use the following technique if you use an Oracle version prior to 8i: Create a compressed export on the fly. In 10g, we can compress only METADATA's but from 11g onwards we can compress DATA's also. I did a fresh install of Oracle 9 (the version the client is running) and the management tools. But I need to copy a oracle database and all it’s data to my oracle XE. Home » Articles » 11g » Here. After verifying that the data has been imported successfully, you can delete the dump file. To export the data from Oracle using the command line Change the active code page of the command prompt. SYS_EXPORT_TABLE_01 is:. Some friends suggested that it is possible through command prompt. After you import the trunk. Version Export In your case, both the export (expdp) and import (impdp) are with Data Pump and you can use the version [parameter to export from a later release of Oracle an import that dump file into an earlier release of Oracle. How to import an Oracle dump file. Specifies which data to compress before writing to the dump file set. Applies to: Oracle Database - Enterprise Edition - Version 10. ova file extension. From this table, Oracle will find out how much job has completed and. At the Project menu, select Import from file. Depending on the type of data, you probably can export up to 10 gigabytes to a single file. Note For MySQL 5. Since their format is incompatible with their predecessors, Export and Import, the utilities are not interchangeable. I need to migrate the AOL data into an xl sheet, like all the concurrent program related data along with the parameters it uses and the value sets associated with it will be stored in one tab. Hi, I've an export dump file which is compressed & it's of size 20Gb, the actual size of the file is 60GB,i don't have that much free space, so i want to import using this dump file in the form of compressed itself,Is it possible to do like this? Please if any one knows how to do this,please let me know. I'm using Linux the example. Data Pump Import Parameters. Importing oracle procedures may be hard i suppose, i'm not sure if oracle and postgres have the same syntax. Here is the script that achieves this:. But in original export/import we could directly compress the dump by using pipes. With the following instructions you will be able to transfer a VM across several different physical machines and it's also a good way to make backups. Z), imp sits around until it reads the whole file. Following are the steps, in Oracle 9i database 1) create a TNS alias (ora10) in your tnsnames. Compressed files are typically unusable until you extract them from their ZIP folder. The dump file set then can be imported by the Data Pump Import utility on the same or another Oracle Database system. Two days before, I came across the situation where I was need to do export/import schema from UAT to DEV, but none of the mount points on filesystem were having sufficient space available to fit export dumpfile. Oracle newbie may also find it is very easy to Export/Import data objects with this tool even without typing an Export/Import parameter. Importing CSV files gets a bit complicated when you start doing things like importing files with description fields that can contain punctuation (such as commas or single-double quotation marks). But in original export/import we could directly compress the dump by using pipes. My intent is to import in an existing DB, as opposed to setting up a new DB instance just to accommodate the full export I have been given. 0 or False is no compression. increase the quota if there is space in the zpool left 2. It also includes importing a DMP file (a dump) from another system. Get list of all tables in Oracle? 4945. Then, load the data using one of these methods. About cx_Oracle. Data Pump compression is fully inline on the import side as well, so there is no need to uncompress a dump file before importing it. Since their format is incompatible with their predecessors, Export and Import, the utilities are not interchangeable. In the next window choose the restoring type. Here is an example on how to import a Oracle database dump file (a binary file that's exported from a Oracle database using the Oracle data pump utility). In the following compression example from the Oracle sample database, the oe and sh schemas were exported while simultaneously compressing all data and metadata. Valid keyword values are:…. We have a need to export AWS RDS oracle database data from one VPC to another VPC. 7)Sequential media, such as tapes and pipes, are not supported in oracle data pump. rdsadmin_s3_tasks. 1 On the Fly compression with Oracle Exp and Imp tools On Unix environments, it has been largely used scripts allowing on the fly compression of the dump file generated by exp utility. This is where the contents of the dump file will be imported. Data Query between BDA and Exadata (Part 2): Query Oracle Table from Hive on BDA Data Query between BDA and Exadata (Part 3): Load data from BDA to Oracle Table on Exadata Using OLH When moving data from Oracle Database to Hadoop, I discussed the approach using Sqoop in this blog. Compression of dumpfiles with EXP/IMP/EXPDP: One of the biggest challenges for DBAs is the lack of disk space especially for the backups. Home-> Community-> Mailing Lists-> Oracle-L-> Re: Import from a dump which was split and compressed while export. Download Nandub free. All other non-string data are stringified with str() before being written. How To Import One Table Back from a Dump File? - A collection of 27 FAQs on Oracle loading data and exporting data. 5) The oracle server provides two major oracle driver to read the flat files. In this article, we'll talk about step-by-step or how to export an Oracle database, then import into a different schema name. Oracles Data Pump Utility EXPDP and IMPDP. As usually the dumps can be very large files, it is advisable to compress the dump. Clear answers are provided with tutorial exercises on saving data as flat files, loading data from flat, exporting and importing database, schema. But import fails with IMP-00033: Warning:. Hi All, I am usign Oracle database 10g, anybody havign any idea of how to compress your dumpfile using expdp then let me know. 1 uses dump file sets of version 4. That file will be created compressed on the fly. With Advanced Compression, Oracle includes table compression targeted at OLTP workloads, resulting in reduced storage consumption and improved query performance while incurring minimal write performance overhead. In 10g, we can compress only METADATA's but from 11g onwards we can compress DATA's also. I need to import only that particular table from the. Active 10 years, 1 month ago. If you’re using a graphical Linux desktop, you could also use the file-compression utility or file manager included with your desktop to create or extract. For more information about Oracle (NYSE:ORCL), visit oracle. We need to setup the database so we can connect to it and debug a problem. Thanks, -Prasad. Default: METADATA_ONLY Purpose. dmp) files with Oracle's export (exp) and import (imp) utilities, you can compress and uncompress the dump file as needed using gzip and gunzip (from GNU) or the unix compress and uncompress utilities. Double-click on the OVF or OVA file. Dump file encryption can also be used in conjunction with the dump file compression feature. Is there a way/ option in expdp where the dump file will be automatically zipped wh | The UNIX and Linux Forums. COMPRESSION Reduce the size of a dump file. Backing up a database. Data Pump is modeled after Oracle 12c's Export/Import tools that were available prior to Oracle 10g. Active 10 years, 1 month ago. ORA-39142: incompatible version number 5. While export I got is "export terminated successfully without warning" but at the time of import, after successfully importing few tables it gave me the following errors at the end. Heck, even with a local import (imp file=local. Following are the steps, in Oracle 9i database 1) create a TNS alias (ora10) in your tnsnames. If your Oracle server is available you could connect to it using an ODBC driver and perform the import with the source being ODBC and the destination by SQL. 5) The oracle server provides two major oracle driver to read the flat files. Follow these steps to run a Data Pump Export with this parameter file: Type the parameter file into a text […]. Just copy the file over or setup a connection to it. Run the import for the second dump file created in step 2 that imports data without. The dump file set is made up of one or more disk files that contain table data, database object metadata, and control information. For more information about Oracle (NYSE:ORCL), visit oracle. Decompress ZIP file example. 6)Expdp/Impdp operate on a group of files called a dump file set rather than on a single sequential dump file. however all these utilities are i/o intensive and take considerable time to do their jobs on large files. MyDumpSplitter-Extract split database or tables from mysqldump | MySQL dump splitter The Mysqldumpsplitter can extract database, table, all databases, all tables or tables matching on regular expression from a mysqldump. The compressed dump file sets are automatically decompressed during import without any additional steps by the Database Administrator. Hi Amit, I received 4 dump files for a client database that he exported on same file share directory. But when I , Impdp Multiple Dump Files in Oracle 11G Standard Edition, Oracle Forum. You can compress the export dump files in all the directories on disk while using parallel processing. This article introduces a small number of new features for external tables in Oracle 11g. Objects exported by Data Pump Export Utility can be imported into a database using Data Pump Import Utility. The Parameter file is a file that Toad will create on your PC which contains the settings for the Data Pump export. At the end of this tutorial is a quiz you can take to test your learning. we have this large file right now. This article provides an overview of the main Data Pump enhancements in Oracle Database 11g Release 1, including the following. How to take a DB Dump and Restore it in Oracle RAC 11gR2 7:33:00 AM 2 comments In this post I'll explain you how to take a DB dump in Oracle with deprecated imp/exp and using oracle data pump. 1 to version 4. Compressed files are typically unusable until you extract them from their ZIP folder. This is the default. We don't use Oracle or have any in-house Oracle expertise. Connected to pluggable database pdbtestdb and created a directory "TEST_DIR"(as usual we have been doing in previous releases of oracle database) where I have kept the export dumpfile which was exported from oracle 11g database and tried usual method to import inside Oracle 12c PDB. I'll cover the following topics in the code samples below: SQL Server, Microsoft SQL Server, Oracle, EXP, Database, Import, Dump, Import Data, and Oracle Data. This file is used to exchange or export/import data from relational SQL databases, contains various SQL instructions etc. What is good compression algorithm that can be used for Oracle. PostgreSQL supports zlib compression. In 9i, I used to export and then gzip the dump file, but with 10g, oracle expdp could compress the METADATA, but with 11g, I can compress everything. A client sent us an Oracle database we need to test against. Use the zipinfo command to view a list of files in the. Oracle newbie may also find it is very easy to Export/Import data objects with this tool even without typing an Export/Import parameter. During an export operation, data is first compressed and then encrypted before being written to the dump file set. Thanks, -Prasad. The UTL_COMPRESS package can be used to compress and uncompress large objects (raw, blob or bfile). Two days before, I came across the situation where I was need to do export/import schema from UAT to DEV, but none of the mount points on filesystem were having sufficient space available to fit export dumpfile. Q14 =I have an expdp dump file without its log file with me and i have no access to the export file's source DB. How to Restore a Database Backup Using. Oracle_loader: This is used for the reading the flat files using the oracle loader technology. I have an internal customer that does oracle backups and then uses gzip to compress them. How to import. Datapump (impdp) in oracle 11g. 7 is required. Oracle provides a utility named mysqldump which allows to easily export the database structure and data to an SQL dump file. What tools are needed in order to convert a dmp file to csv? We have no database guy at our company and were given a dmp file that needs to be in csv format before we can hand it off. This is where the contents of the dump file will be imported. (3 replies) Hi All, The compressed dump export file size of my database is more than 2 gb and my OS file size limitation is 2 Gb so I compressed and split it into two parts while export. 1) and later. Connected to: Oracle Database 12c Enterprise Edition Release 12. zip archive. I've installed Oracle 10g and now i need to restore the original database. Anybody has any ideas, please share them. One problem with this is that you will still have to have the large dump file on your disk at some. The dump file set consists of one or more disk files that store table data, database object metadata, and control information. The large size of the dump file is essentially due to one large table with more than. my file is in binary numeric data and inorder to open that file I have to open it with the help of Hex editor tools and i need to import that data into workspace so that i do buffer operation over it and my commands for reading that data are like this but I am facing trouble when i use 'from workspace' block in simulink to get the data from B. It is not used in the details below, but just in case you ever need to export from 12. COMPRESSION parameter is used with EXPDP, to compress the generated dump file. You can take that dump file to Linux, Windows, Unix, etc. 5) The oracle server provides two major oracle driver to read the flat files. Dump and Compress. Import internally converts contents of export dump file to DDL and DML statements. Create a named pipe and use zcat or uncompress in background to read from the compressed file and redirect the output to the named pipe. The COMPRESS function is often used to remove blank spaces from a character value. NOTE – For using compression parameter with datapump, we need to have Oracle advance compression license. A full import is specified using the FULL parameter. Hope Oracle May introduce this in Upcoming Versions. ftp or copy the dump file arjun. hi masters i used toad 8. For information about Data Pump Import and Export, see these topics: "Data Pump Export Modes" in Oracle Database Utilities for Release 12. A client sent us an Oracle database we need to test against. You can use SSIS to build extraction, transformation and load (ETL) packages and to quickly create packages for moving data between Microsoft Excel worksheets and SQL Server databases. external table enhancements in 11g. This tutorial series uses data describing Olympic Medals, hosting countries, and various Olympic sporting events. It conforms to the Python database API 2. This can be done in two ways. In this tutorial we will see how we can export and import the content of one Oracle Schema using Oracle tools called EXPDP and IMPDP Toggle navigation AODBA. By using “Import from Files” under data movement section of the OEM. You can use the Sqldumper. DMP file in Oracle 10g with the size of 20GB takes almost 1 hour to import, but Oracle 11g version takes almost 3 hours for the same. How can I similarly import it. This directory must point to a valid directory on the same server as the database: Execute following commands as sysdba. At the Project menu, select Import from file. Any help is appreciated. The following describes how to use Data Pump Import utility to import objects. Each thread generates output in its own file, so the result of the parallel export job is a set of files. Compressing files in modern operating systems is usually pretty simple, but things can get more complex when the files are large. cx_Oracle is a Python extension module that enables access to Oracle Database. While this isn’t a reversible transformation, it makes it easier to dump SQL NULL data values to CSV files without preprocessing the data returned from a cursor. ; Create a database on the target server. For all practical purposes, think of UTL_COMPRESS as PLSQL's means of compressing or zipping files. The AWS documentation about using Oracle data pump is very un-clear and very difficult for non-DBA to understand. Being a remote server should not be an issue. 1 in dump file “xxx. Use DBMS_DATAPUMP to create a dump file Create a database link to the target DB instance Use DBMS_FILE_TRANSFER to copy the exported dump file to the Amazon RDS instance Import the dump file into a database on the Amazon RDS instance Clean up. By using “Import from Files” under data movement section of the OEM. EXPORT AND IMPORT: in 11g COMPRESS import into one extent (Y) RECORDLENGTH length of IO record FILESIZE maximum size of each dump file STATISTICS import. Sometimes, the space on disk may not be enough to hold a full export dump if uncompressed. ova file extension. In some organizations, encrypting data is mandatory, and as you might expect, it can exact a performance penalty. However, it can also be done by using SQLPlusHow to Import a dmp File: CMD sqlplus system/systemSQL create user (username) identified…. I first tried to use S3 as a hosting site for the. I have an Oracle Dump file (. When your import file path was wrong you may get a prompt like below and you may wonder how to exit from it. The following is supposed to outline what could go wrong and how to go about it the right way. You either have to use a) SSIS: SQL server integration services b) Create a linked server in SQL Server to ORACLE. Then i managed to copy this dump file into RDS Oracle and confirmed it existed in RDS. I have dmp file that was created by EXP utility. How to process parallel export Oracle dump files. Yes, expdp of 11g has more compression options than erstwhile 10g $ expdp help=y : COMPRESSION Reduce the size of a dump file. In fact, in a dump file, there may be one or more SCHEMA. While export I got is "export terminated successfully without warning" but at the time of import, after successfully importing few tables it gave me the following errors at the end. 6) How to View a List of Files in the. Hi All, I would like to ask how can imports my dump oracle database file data and struct into sql server 2005 with out make connection oracle. If you're going to use the mysql client you will have to transfer the dump file to the server ( use ftp or sftp/scp ). I realized that if it’s not a simple things, it didn’t like MySQL (just a bit effort to export and import by sql file). Some Important. Dump file encryption can also be used in conjunction with the dump file compression feature. rdsadmin_s3_tasks. COMPRESSION parameter in expdp One of the big issues with Data Pump was that the dumpfile couldn't be compressed while getting created. This following command needs to be typed in at the c: prompt, and assumes that the dmp file is in the root C: drive. Allows you to rename tables during an import operation. sql file into MySQL via command line: mysql database_name. Of course Oracle did not make this information public, but if you can access MOS, then go ahead: Export/Import DataPump Parameter VERSION - Compatibility of Data Pump Between Different Oracle Versions (Doc ID 553337. How can I replace it with the table which I have it in the old dump file which I create every week? Can anybody help me out? It is urgent please. I have an old database backup from my oscommerce store stored as an.