Tuesday, July 26, 2005

I can't restore database

Quoted from an Invision Power Board.
Two days ago, I bought a new shared hosting 20GB space. After I have tried to restore my database but I didnt work because the file is so big over 150MB. I have tried my time but it is still stucked. I used phpMyAdmin but I still got trouble with overtime.

So anyone can tell me the way I can restore a big file to my SQL.

Thank you so much,

Tony Tran

====

Is it possible to cut it up? I don't know anything, but that could be a solution.

====

I've posted a similar post like this.. Don't remeber where..

Look in the General talk for a topic about Mysql.. They have a tool for it somewhere in the help files located online @ the main page ( if I'm right )

====

Thank you for quickly reply. I read your two instructions but I am confused with MySQL Document

To install the script:

1) If you wish to password protect the script (recommended)
edit the line $password = ''; at the top of the file
mysql_tool.php putting the password between the quotes.

2) Upload the contents of the extracted zip file
( mysql_tool.php and tile_back.gif ) to your web host.

3) Ch-mod the folder you have uploaded the tool to writable (666)
using your FTP client

-> What is the folder I should edit CHMOD and create? And where I put it in?

Thank you so much,

Tony Tran