Linux Commands phpMyAdmin with Tables!

[Vrotz]

Hi,

I have a database and want to export only the tables of accounts and players. That done, I need to transfer these tables into my new database. How I do it using the ssh commands? I have two tables in hand, now I need to import them into a new database that has been created.

Thanks.

 

[Cornex]

Hi,

I have a database and want to export only the tables of accounts and players. That done, I need to transfer these tables into my new database. How I do it using the ssh commands? I have two tables in hand, now I need to import them into a new database that has been created.

Thanks.

Why do you want to do it in ssh? Isn't it easier to do it in normal way?

 

[Vrotz]

Why do you want to do it in ssh? Isn't it easier to do it in normal way?

Hi!

I use Debian and I cannt import the tables by URL, idk.

 

[Vrotz]

Bump

 

[Hooloovoo]

Why do you want to do it in ssh? Isn't it easier to do it in normal way?

You probably mean that the norma way is phpmyadmin, which is the most common way but it takes up abit of extra resources and you can manage the database just fine through SSH .

@Vrotz Sorry, I can't help you Try google, I'm sure it's a common question

 

[Ninja]

Try with something like this

mysql -u username -p -h localhost databasename < schema.sql