100np$ for MySQL Help

[Ik]

[Resolved] 100np$ for MySQL Help

Resolved

I'm paying 100np$ for the person who helps me with this.

I have a MySQL database that I want to restore using MySQL Administrator, but I keep getting the error attached.

The file I'm trying to restore is a .sql file.

I will pay only if the problem is solved.

No PMs, just post here please.

Thanks

 

[averge]

what about read the error? that backup was generated in another program, so you must convert it or generate in correct program...

 

[elangnet]

Do you have SSH access to the server ? Because it would be easier to restore database from a mysqldump backup file using shell command as root / SU

 

[Ik]

I'm installing both MySQL 5.0 and MySQL Administrator on my local machine (xp).

 

[serialCoder]

try using a web based mysql manager like phpmyadmin to do your restore

 

[Ik]

try using a web based mysql manager like phpmyadmin to do your restore

I would like another solution as I don't have these tools. Thanks

 

[elangnet]

What server do you have in your PC ? xampp or another distro ?
Either way, try to locate the sub directory mysql/bin from windows dos command to find the location of mysql.exe

this example assuming that the subdirectory located on C:/appserv/


C:\AppServ\mysql\bin>dir /p/w

it should show something like this
Volume in drive C has no label.
Volume Serial Number is F8D9-6881

Directory of C:\AppServ\mysql\bin

[.] [..]
libmySQL.dll mysql.exe mysqladmin.exe
mysqlc.exe mysqlcheck.exe mysqld-nt.exe
mysqld.exe mysqldump.exe mysqlimport.exe
mysqlshow.exe mysqlshutdown.exe mysqlwatch.exe
perror.exe mysqlbinlog.exe

then copy the mysql file into this folder

Make sure the mysql server is running.
Now you can import the database using this command (assuming the mysql file name is alldb.sql)

C:\AppServ\mysql\bin>mysql -uroot -p < alldb.sql

 

[enlytend]

Assuming the mySQL server is running on your machine and that the mysql executable is in your path:

Open a command prompt, then:

mysql --host=localhost --user=root --password=yourrootpassword -v < yoursqlfilename.sql

If the sql file needs a database that already exists:

mysql --host=localhost --user=root --password=yourrootpassword -v databasename < yoursqlfilename.sql

The -v is optional - it gives you verbose output so you can see what's happening.

if mysql.exe isn't in your path (on a windows install it SHOULD be), either run the command from the directory where mysql.exe is found or add it to your path.

 

[Nodws]

open SQL file on text editor, and remove all comments
try modifying the charset on the mysql restore manager before upload

 

[serialCoder]

I would like another solution as I don't have these tools. Thanks

if you have php/mysql installed on your local machine, installing it is as easy as unzipping files

or i think the mysql.exe solution is also easy, just go to command prompt, run the mysql excutable and let it process the sqldump

 

[Ik]

It seems like all solutions are right. I managed to retrieve the database, so I have decided to give 100np$ to each one tried to help.

Thanks all.