Importing .sql files on Windows ? .SQL hangs saying too large script error everytime

[SaN-DeeP]

Hello All,
Trying to be clear with my problems :)

I am running on Windows XP. I have installed foll. things.
Mysql, php and iis. vb 2.3.4 runs fine on new installation :)

What i want to acheive.
1. I have IPB 1.3 running on my current forums, which needs to be upgraded to vbb. but as it is HEAAVILY MODDED. i need to edit the DATABASE back to its original structure. before converting it .
2. I have a backup copy of my IPB 1.3 Database from my host (running on linux)
it is in .sql format.
I tried to open the .sql file in a file editor and manually done copy/paste operations and created the database on my local machine. but it takes in more then 2 hours to do it everytime :(
As it is a 15 mb file.
I am using EMS mYSQL Manager to do this.

If i copy/paste the entire .sql file and execute it it halts.. giving too large script error everytime.

Can you please tell me a simple and perfect way to do this ??
I have a .sql file of 15 mb (uncompressed) which needs to be exported to make a database.
Please let me know about some perfect tools, or command. which can do this.
As ems sql manager hangs the scripts..

Waiting for some suggestions :)

Thnx.
Sandy...

[AWS]

Use mysql to import the db. When you import into vbulletin the importer will disregard the tables and fields added by the hacks. It will only import what the importer is set to do.
The hacks won't interfere.

[SaN-DeeP]

:confused: :confused: :confused: :confused: :confused:

[Steve Machol]

This is because backing up or restoring with a PHP script can result in PHP timeouts errors and an incomplete backup file. The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

http://www.vbulletin.com/manual/movingservers.html

[SaN-DeeP]

Hi steve,
I am doing this on windows. on a local machine for testing purposes.
i dunt know how to do that telnet ssh installation on windows xp machine locally.

are there some tools, apart from it. to do the .sql to database converstion ?
i tried phpmyadmin but that is too slow i have to manually cut down the script to smaller bits :(

nothing is going @ one go.
i will have to test the db many times. as i need to uninstall more then 35 mods. and then upgrade to IPB.

i am looking forward to buy the owned license for VBB. but i need to complete with the installation part first ....

And i am running out of time now, 1 week already over, since i bought VBB :( but cant do anything. :(
atleast tell me about .sql to dabtabase making procesure. i will take care myself to uninstall the mods.

Regards,
Sandy...

[Steve Machol]

To restore a db dump file, log into the server shell and trun this command:

mysql -uUSERNAME -p newdbname < /path/to/dump.sql

...of course substitute the appropriate values as needed.

What specific problem are you having installing vB? Installation does not require restoring any databases.

[SaN-DeeP]

i am trying to use UniServer on Windows XP.

that command doesnt works :(

just gives me list of all the commands

[Steve Machol]

What do you mean 'a list of all commands'?

[eva2000]

try editing php.ini on winxp and set very high timeout values for php and then edit my.ini or my.cnf on winxp and try these settings and restart mysql


[mysqld]
max_connections = 500
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M


as to running command line use Start Menu -> Programs -> Accessories -> Command prompt and change to mysql install directory which contains mysqladmin client