İmporting a Massive big sql file to mysql?
923590
If it's a standard .sql file, you should be able to split it. This would break transactions, but depending on the statements in the file this may not be an issue.
195827
Some of the data you were trying to append was probably too big to fit into the fields in your database (eg. you might be trying to fit 20 characters into a 15 character field).
287525
I have done it before, you just need to convert the file to an array of bits and save it in your sql server as image.
733537
Copy libmysql.dll into the PHP directory.
448734
I've had a lot of problems with this migration. Upgrading it in place gave me all kinds of security problems. What I finally did is:\n\n- Make a copy of the SQL 2000 db\n- Upgrade the copy\n- Detach the databases \n- Copy in the 2000 mdf and ldf files\n- Reattach the databases\n- Upgrade from 8.0 to 9.0 format.
36483
If you have PHPmyAdmin installed it will do it for you. Just export it and choose XML.\n\nWhatever you do don't use anything MS to create your XML - your file sizes will be humongous (3-20 x larger then they should be) and it will be insane to try to edit/find what you need.
1007417
Hi..\nCheck out the following page...this might provide your some insight on Query Optimizations...\nhttp://www.sqlsummit.com/Optimization.htm
292988
Depends on the file that needs to be imported, and how you need to import it.  Enterprise manger comes with an import wizard that you can use to import information.  sometimes it's easier to just import the whole thing and delete what you don't need/want.\n\nanother way would be to make the file into a CVS and import that into access, then by using a linked table, export the table to SQL.
673694
PHP is probably the easiest, but MySQL is muchos needed.
1068469
download MySQL query browser and MySQL administrator from the mysql.org site. They're free and easy to use.
664122
SQL Plus has its own system to put query in file.\nyou type 'ed' at SQL Plus prompt and notepad editor edits your querry.\nYou can save as query by selecting save as "All Files" then giving the file extention to .sql\nhope this will solve your problem.
644162
it's just like connecting to a local one but with a full path\nin mysql_connect()  ex:\n\n$link = mysql_connect('example.com:3307', 'mysql_user', 'mysql_password');
361351
You can do this with ASP>net and SQl connection object.\nYou can also use Jav and JDBC
254436
write a script in sql*plus:\n\nSET echo OFF\nSET verify OFF\nSET feedback OFF\nSET pagesize 0\nSET linesize 180\n\nspool DROP.SQL\n\nSELECT 'drop table &&1' || '.' || table_name || 'CASCADE CONSTRAINTS;'\nFROM ALL_TABLES\nWHERE owner = '&&1';\nspool OFF;\n\nSave this as create_drop.sql, then run with\n\nSQL>@@create_drop USER\n\nwhere USER is the user you want to drop, then run drop.sql\n\nSQL>@@drop\n\nGOOD LUCK
874841
U can go for truncate command.\n\ntruncate table <table_name>\nLoop thru all the tables.
598111
You can use PHP and read/write to a MySQL Database.\n\nHere is one good tutorial:\nhttp://webmonkey.wired.com/webmonkey/programming/php/tutorials/tutorial4.html\n\nIf you need additional help you can email me,\neoffice4u@gmail.com
56650
From Enterprise Manager, select the database and go into "all tasks->import/export data...".