Can SQLyog perform inserts along with functions as phpMyAdmin? Particularly in Data View.
Currently, in Table Data tab you can add 'inserts along with functions' in grid mode and save the data. Once you add data, it converts the value and save in grid. and See image 'function.jpg' and 'Result.jpg'.
We've put your request for a feature in our issue tracker. We will discuss about this and keep you updated on this.
Yes. Also, all dependent tables (if any) should be aware of this change to the PK in table. Ex: In DB2:animalTable the PK for Dog and Fish is 1 and 2 . After DB3 creation, it becomes 3 and 4.
You can use 'IMPORT EXTERNAL DATA TOOL' from Powertools menu or simply click CTRL+ALT+O. Follow the steps to achieve your result:
1. You have created 2 databases with tables (DB1 and DB2) and empty database (DB3).
2. Open 'IMPORT EXTERNAL DATA TOOL' from Powertools menu.
3. Create a new MySQL DSN for DB1. See image 'mysqldsn.jpg'. Similarly to Db2.
4. Select the target database DB3 to import data from first database DB1.
5. Now select tables and run the task to import data to DB3.
Now, you have successfully transferred data and their table from DB1 to DB3. Open table from DB3 in TABLE DATA tab to view the data.
6. Now again open 'IMPORT EXTERNAL DATA TOOL' from Powertools menu and select MySQL DSN for DB2.
7. Select target DB3 to import data from DB2.
8. In 'Select Table(s)' –> Map wizard, uncheck PRIMARY COLUMN from wizard. See image 'mapping.jpg'.
9. Open 'Select Table(s)' –> Advanced options wizard. Select 'import into existing' and 'keep target data' options from wizard. See image advancedoptions.jpg'.
10. Run the task.
For output see image 'tabledata.jpg'. You will get the resultset as expected.
Thanks for information. We will try to reproduce at our end and update status.
Quote:
What is causing the *.dmp files to be generated?
Dumps are the files which are created if application crashes and these are the dumps which was created in 2008 and is of no help now. So, in future if you get any crash dumps please send to us so that we can find out what is the root cause for that particular issue and nail down them easily.
“If a sqlyog.ini files exists in installation folder it should be copied to 'AppData' folder. This is required for upgrading from versions before 6.06. However with latest releases an empty file was created in 'AppData'.”
The file position is:
Windows 2K/XP/2003:
C:Documents and SettingsUserApplication DataSQLyog
Windows Vista/2008/7:
C:Users{user}AppDataRoamingSQLyog
Note that 'AppData' folder is a hidden folder (you unhide from Control Panel … Folder Options) and also note that some folders may have localized names.
We will also try to reproduce this issue at our end as we encountered same long before. BTW please tell what is your OS?
To merge 2 MySQL databases into one you can use “Database Synchronization” or simply use “Copy database to different host/database”.
Quote:
Can webyog be used to merge these two databases into one database? i.e DB1 + DB2 = DB3.
To do this first create “DB3” database where you need to copy tables and their datas from DB1 and DB2 into DB3.
A. Using “Database Synchronization” tool from Powertools Menu. (right now we are supporting for single database only at a time):
To perform this first select Source db “DB1” and Target db “DB3” and similarly “DB2” to “DB3” by checking option 'One way synchronization'.
You can select 'Generate script' option from the wizard as shown in image “data sync.JPG” and edit the script in any editor by selecting only UPDATE statements. You may run Data Sync between master asand slave as , any difference between master and slave will result in INSERTs/UPDATEs/DELETEs on slave.
(but note this article is not up-to-date, but principles are the same).
Additionally, a very important point to notice is that the Primary Key on every table must be defined in such a way that the same value for the PK will never be created for different data on different hosts.
B. Another option is to use “Copy database to different host/database”. First select source DB1 and target DB3 and copy the data. Similarly follow same to copy from DB2 to DB3.
navyashree.r
Member
