Tag Info

New answers tagged

0

First, make sure this chunks/datafiles are from Windows OS too. Isn't compatible read a datafile froma different plataform (windows VS Unix VS Linux) You cannot just move the chunks/datafiles and expected the engine just re-adapt to new path. There internal pointers at theirs configurations where the path is saved and need some administration steps to ...


5

Look into BCP or BULK INSERT, both of which can share format files. Quick math based on pure guesses, since no hard details are given: 13 numeric columns, pretend they're 6 bytes each on average = 13*6=78 bytes. 5 VARCHAR columns, pretend they're an average of 300 bytes each based on the "largest" being VARCHAR(1000) per the original question = 5*300 = ...


2

Indexes are not disabled in InnoDB using DISABLE INDEX (from http://dev.mysql.com/doc/refman/5.1/en/alter-table.html): For MyISAM tables, key updating can be controlled explicitly. Use ALTER TABLE ... DISABLE KEYS to tell MySQL to stop updating nonunique indexes. Then use ALTER TABLE ... ENABLE KEYS to re-create missing indexes For InnoDB, you're stuck ...


0

Thanks. I have imported dmp file by following steps.. Command to open SQLPLUS In Command Prompt: C:> sqlplus / as sysdba Clear Screen: SQL> Clear Screen 1- First create a new user by SQL> Create user TestUser1 identified by test; -- (test is password) 2- Grant Privilages to new created user TestUser SQL> Grant dba, IMP_FULL_DATABASE, ...



Top 50 recent answers are included