Be gentle im new so if this is in the wrong area i apologize...

I dumped a database from a linux server co-located somewhere else and wanted to put it on my windows machine here at home. When i try to dump the database into the windows machine here at home i get a No SQL Query. Its set for 8 megs but database is 4 megs, I dont get it..... Anyone have any ideas as to why it does this and how to fix it????

Could you explain with a little more detail? I'd be happy to help you but I don't quite get your question.

What database, what commandline to get the dump.. etc..

im using PHPADMIN im not to familar with commands, just point and click... the database on the linux server, I click save as and download the database as one file..... then to put it on my windows machine... same thing use phpadmin... click browse and then click go

Originally posted by DigiCrime
im using PHPADMIN im not to familar with commands, just point and click... the database on the linux server, I click save as and download the database as one file..... then to put it on my windows machine... same thing use phpadmin... click browse and then click go


phpMyAdmin will timeout when trying to add the contents of a 4mb database, it would just take to long, and the http proccess would time out.... Do it from command line, let me see if I can find a tutorial on how to do that on a windows box...

I looked for command lines myself i didnt see any, thats what somewhere else said as well. If anyone has the commands to dump a database into like so with commands for a windows machine AND linux THAT WOULD BE AWESOME!!!!!

Hi,

If you still have access to database on server, simply compress your database on server, receive to local machine and put it in your local folder.

... will not forget to decompress :)


Regards,
Eugene

Go to cnet and and look for MySQL Front... It is a great program to admin your databases with. Plus its free.

I handled a 2MB database on it pretty good, so I think it can take a 4 meg. ;)

Now if hosts would just let remote connections to MySQL for remote admin ;) (I already know the security issues though :( )

just my suggestion...

Originally posted by erapid
Hi,

If you still have access to database on server, simply compress your database on server, receive to local machine and put it in your local folder.

... will not forget to decompress :)


Regards,
Eugene

I tried that program but all it does is freeze on my system, doesnt do anything :(.... any other ideas??

Hi,

At first, I think you may ask for help from your new hoster :)

What about my solution

Every MySQl database is a catalog somewhere on the server. It includes files named MySQL tables.
So, If you need to copy large database you may do

- tar -zcvf db.tar.gz /path/to/your/database
- send db.tar.gz to another system
- uncompress, it relays on your operation system: if linux "tar -xfzv db.tar.gz /newpath/to/your/database", if win ... you may use WinAce for example

there is only one question - where is your database location

Regards,
Eugene