problem in mysql

Naeem Khan

hello every one, well my problem is that i have one root database folder of mysql...(frm file) i want that when i copy of my database folder(all frm files) in diffrent system then its not opening in mysql its says "table Does not exists". but i want to open all tables. if this is possible in mysql then let me know please its too urgent........... thanks in Advance

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gokula Krishnan16y ago
Hai Naim Khan,

Did you heard about MySQL Administrative tool. This tool is free of cost. Down load from mysql website. This tool provide many options. There is the query builder, Import , Export options, ....

Try this tool. You feal better...

Regards,
GokulaKrishnan.
0
Kirtan Patel17y ago
Friend,

My SQL Stores File Differently then The SQL Server SQl Server Stores Data in Single File But MYSQL makes Diffrent File For Each table . also mysql can not be used as Local database as We Use mdf file as local database ..

0
Naeem Khan17y ago
Hello sir, sir still i did not get the solution of mysql database file. will you please tell me did you understand what i m asking you if yes then please reply me as soon as possible.... like in Sql Sever 2005 we have mdf. file which is structure of our DataBase. if i m going to client then i will take this file and can also do blank of my database . but i dont know which file is structure of database in mysql............. so please tell me what should i take file when i m going to client . hope you understand sir what i want............ thanks in Advance Naim Khan
0

Kirtan Patel17y ago

On Source Machine Execute this

 mysql -u username -p databasename < dumpfile.sql

you will get dumpfile.sql as output 

Now On Machine where you want to copy database .Create a Blank Database .

then run following command 
 mysql -u username -p Blankdatabsename < dumpfile.sql

Naeem Khan17y ago
hello sir, sir please explain me with example . my database name is Naim and importantly where to write it..i just copied the folder in my local machine from Server . but i m not the able to see tables in mysql its showing me table does not exists. please tell me its too urgent..... thanks in advance
0
Lalit M17y ago
could you try this way ?you can also tack a database dump and transfer another system try this

Usually you run mysqldump to create database copy:
$ mysqldump -u user -p db-name > db-name.out

Copy db-name.out file using sftp/ssh to remote MySQL server:
$ scp db-name.out [email protected]:/backup

Restore database at remote server (login over ssh):
$ mysql -u user -p db-name < db-name.out

copy a MySQL database from one computer/server to another

Short answer is you can copy database from one computer/server to another using ssh or mysql client.

You can run all the above 3 commands in one pass using mysqldump and mysql commands (insecure method, use only if you are using VPN or trust your network):
$ mysqldump db-name | mysql -h remote.box.com db-name

Use ssh if you don't have direct access to remote mysql server (secure method):
$ mysqldump db-name | ssh [email protected] mysql db-name

You can just copy table called foo to remote database (and remote mysql server remote.box.com) called bar using same syntax:
$ mysqldump db-name foo | ssh [email protected] mysql bar
Another Way may be help
0

problem in mysql

copy a MySQL database from one computer/server to another