Copy table in a Database

pirri

Is possible copy a table (files .frm, MYD, *.MYI) inside of the database MySQL?. The database is in a commercial host and I have the user and password.

What can I do?

Thanks.

nnichols

Yes is the simple answer, but as is always the case it is not that simple.

Do you have admin/root access to the server/box?

You can copy tbl files this way but it is not quite as simple as just moving and/or renaming them.

It is possible to create a copy of a table in SQL using -

CREATE TABLE new_tbl_name SELECT * FROM tbl_name

Hope this helps 😉

pirri

I have access to the database with the ip host, user and password, but I have not acces to the root of the database host.

If I use you sql for upload the table, that file I have that put (table.frm, table.MYD or table.MYI) or all.

Thanks

nnichols

Use MySQL-Front. It will do all the hard work for you.

It is available for download from here

Hope this helps 😉

pirri

I have MySQL-Front.

Using the SQL

code:-------------------------------------------------------------------------------CREATE TABLE new_tbl_name SELECT * FROM tbl_name--------------------------------------------------------------------------------

The table is in my computer, when put the root ( FROM tablename). and tha type of file?

nnichols

Use the "Export Tables.." function in MySQL-Front.

pirri

I want to import a table from my computer to MySQL Database (Host), I don´t want export a table.

Thanks for you colaboration.

nnichols

Do you want to copy from your local mysql server to a remote mysql server?

pirri

Yes, but I haven´t MySQL server Database in my computer. I have the files table.frm, table.MYD and table.MYI and want export from my computer to MySQL Database in the host.

Thanks,

nnichols

I don't know of any way you can do it as you have neither root access to the remote server nor a local mysql installation.

I would suggest that you install mysql on your local machine (very easy to do) and then you will need to read up on how to create the database and then copy the table files in.

If you do not want to do this, then you could try contacting your host to see if they will do it for you on the remote machine. They might do it, but it will be expensive.

The only other option is to send me (or someone else on here) the tbl files and we could do it for you, but then you have a security risk in allowing us access to your db.

Up to you.

pirri

Yes, but I haven´t MySQL server Database in my computer. I have the files table.frm, table.MYD and table.MYI and want export from my computer to MySQL Database in the host.

Thanks,

pirri

A lot of Thanks