Dire request for help with sql

[stoneharry]

Hi, thanks for coming to take a look.

Basicly what I need to do is be able to backup my database, then import it again to a different database.
I know how to do this and i've done it many times before.
Problem is, It's no longer working...
I go into sqlyog, I find ascent, Right click, backup as sqldump, structure and data.
Exports successfully.

Ok, time to import it again, restore from sql dump, importing... ERROR!

mmm whats wrong i say?

No database selected...

wtf

I try fiddling around with the settings for hours on end, as i really need this to work if i'm going to release the repack i'm working on...

In the end i cant get it to work, so i get navicat thinking that may be able to get it to work...

new connection

localhost,
root,
*pass*
3306

ERROR, revieved invalid response from SSL...

try a few different settings,

ERROR, lost connection unexpectantly...

I'm starting to wonder if this is a error with my DB and i have to start over... Thats not an answer, I finished this repack, just a couple of bugs to clean up, I am not starting again, I've put months into this...

Anyone got a possible solution? Thanks, +2 Rep to anyone who can help.

~Salamanda

[Aznex]

Did u maybe upgrade your SQLyog?

[stoneharry]

I havn't updated it for about a year now... Am i supposed to update it, and where from?
The database is up to date but sqlyog... Thats another question :P

[Nymphx]

Whenever i've had to back anything up, i've just copy & pasted the files I need into a different location so i'm not too sure about your problem

My way may be noob but i've never had issues with it.

[Exacute]

Use Navicat.. jsut search for it.. much better than sqlyoug

[stoneharry]

Exacute please read the full post? I said navicat wasn't working and some errors *sigh*

[baptizein]

Use MySQL console to import it into your database...

To switch to a new database:

use [database name]

example: use ascent

Then... Import your new database. (Will override all content in that database):

source [path to SQL file]

example: source c:sqlfile.sql

This should do the trick for you.

[stoneharry]

Use MySQL console to import it into your database...

To switch to a new database:

use [database name]
 
example: use ascent

Then... Import your new database. (Will override all content in that database):

source [path to SQL file]
 
example: source c:sqlfile.sql

This should do the trick for you.

ah yeah... I don't know where to find mysql console
I installed my own database into C then when i restarted comp it runs in the background somewhere automaticly... The old repack ones with the exe, yeah i could do that then... But now i don't know where to find the exe :/

[baptizein]

If you are using WampServer, you can find MySQL console at:

C Drive > wamp > bin > mysql > mysql5.0.51b > bin > mysql.exe

Otherwise, it will be accessible from your Start Menu > Programs

[stoneharry]

Error no. 2 when I try to do it with my world DB, but with logon DB it works fine... It's something to do with the exporting it must be, any idea's?

Anyway +Rep for help so far

[baptizein]

Well, I would maybe suggest you delete all the tables out from the world database and try it again. But, if it doesn't work, you would lose that stored information.

[Aznex]

Just to add: Don't upgrade from your current SQLyog or mysql Had people before and the problem was they upgraded, so don't do that But I had the same problem with NCDB, WhyDB didn't have it do :\

[stoneharry]

Damn it, i'm using NCDB... *sigh* I really don't want to start over... I'll see what I can do

[Aznex]

I'm not saying its NCDB, I might have done something wrong when I was using NCDB, but really I didn't have it when I used WhyDB. If I were to be u I would wait until someone like TehSpidey replies

[stoneharry]

ok thanks for all the help