Export,import Data

[toma]

my task is : from client user(database base) create new database(new),

move neccessary tables to it with data.

clientuser has sqlyog enterprise

my answer is:

1 if my client user – administrator, it is possible to create new database.

2 is it possible from client user database base to do export all data using mysqldump to file base.sql

and after it do import to database new from file base.sql (where is base.sql – on computer of userclient or on server?) ?

2 if i want to move only some tables from base data to new data exists command

creat table new.name_table as select * from base.name_table

(if exists can my client user with privilage administrator to do this command)

[peterlaursen]

1) to create a database user needs CREATE privilege in MySQL. and to insert data he needs INSERT privilege. MySQL operates it own user privileges. It does not use the OS (Windows/Linux) user accounts. You can manage user accounts from SQLyog (5.2 supports all privileges)

2) if you create the back-up with the 'mysqldump' program it is stored on the server. If you use SQLyog it is stored on the client (or a network drive that is mapped to the client with a drive letter). However there is a small bug in SQLyog that can affect import of 'mysqldump' dumps (not dumps created with SQLyog itself). It is fixed in the beta tree. You can download latest (non-released) build from here http://www.webyog.com/downloads/betas/not_…SQLyog52Ent.exe if you need to import a 'mysqldump' dump with SQLyog (there is only a REGISTERED ENTERPRISE version as of now, but next beta will have the fix in all versions)

3) if you only want to copy some tables you can create the backup with SQLyog and you can select which tables to copy from the GUI – both the 'export tool' and the 'backup powertool' (actually you can with 'mysqldump' too – but the commandline can be a little tricky then!)). Actually you have also use the 'copy to other host' with SQLyog .. or use the DATA SYNC.

I think it is much easier if you experiment a little with non-important data!

[Author]

Posts