help... phpmyadmin

[bOinkz]

hi guys... please help me... i purchased wanhosting while ago and i accidentally deleted the login in my phpmyadmin...

 

i want to execute a new main.sql again but i don't know how to do it....

 

what commands i use.

Edited December 6, 2014 by bOinkz

[Conflicts]

You can use this command:

mysql -u root -p -D YOURDATABASE < /path/to/rAthena/sql-files/main.sql

[bOinkz]

You can use this command:

mysql -u root -p -D YOURDATABASE < /path/to/rAthena/sql-files/main.sql

 

You can use this command:

mysql -u root -p -D YOURDATABASE < /path/to/rAthena/sql-files/main.sql

 

can you help me please? i tried but it didnt work

Edited December 6, 2014 by bOinkz

[Conflicts]

At least let us know how it didn't work. What error(s) did it give out (if any)?

Or any other useful information that would help us help you resolve the issue.

 

Alternatively, you can do;

cd /rAthena/sql-files

mysql -u root -p -D YOURDATABASE < main.sql

Then type your root MySQL password when prompted to.

[bOinkz]

Alternatively, you can do;

cd /rAthena/sql-files

mysql -u root -p -D YOURDATABASE < main.sql

Then type your root MySQL password when prompted to.

ill show you some screenshots

At least let us know how it didn't work. What error(s) did it give out (if any)?

Or any other useful information that would help us help you resolve the issue.

 

Alternatively, you can do;

cd /rAthena/sql-files

mysql -u root -p -D YOURDATABASE < main.sql

Then type your root MySQL password when prompted to.

sir if youre not bussy can we talk in skype please? i really need some help

heres my screenie 

 

Edited December 6, 2014 by bOinkz

[Conflicts]

You don't have to log on to mysql before issuing the command.

Does the database ragnarok exist in your MySQL installation? You can use the command SHOW DATABASES to confirm.

 

If it doesn't, then omit the -D part, making the command. (Execute the commands on a new Terminal session)

cd /trunk/sql-files

mysql - u root -p ragnarok < main.sql

[bOinkz]

You don't have to log on to mysql before issuing the command.

Does the database ragnarok exist in your MySQL installation? You can use the command SHOW DATABASES to confirm.

 

If it doesn't, then omit the -D part, making the command. (Execute the commands on a new Terminal session)

cd /trunk/sql-files

mysql - u root -p ragnarok < main.sql

cd: /trunk/sql-files: no suck file or directory

[Conflicts]

Only you would know the correct directly of your files. I'm guessing it's /home/YOURUSERNAME/trunk/sql-files

It is beyond our scope, and really, you should ask Wanhosting for support. It is part of their job, isn't it?\

 

Ah, even worse, you're using VNC. So it must be /home/YOURUSERNAME/Desktop/trunk/sql-files