Reboot Issue

[ordnance1]

dbForge for MySql forgets the root password and default database each time I reboot the computer. I check the remember password checkbox each time.

[.jp]

Hello. Could you please provide the version and the edition of the tool you are using.

[ordnance1]

Version 6.3.325 dbForge Studio for MySQL

[alexa]

dbForge saves connections in the following registry branch:

HKEY_CURRENT_USER\Software\Devart\dbForge Common Settings\Connections\MySQL

We recommend you to try creating a connection, close dbForge, and check the mentioned registry branch for the newly created connection.

Also, you can use the following command line switch where you can specify the connection details:

/connection

So, the command line string will look as follows:

"C:\Program Files\Devart\dbForge Studio for MySQL\dbforgemysql" /dataimport /connection:"User Id=root;Host=localhost;Port=3306;Database=weatherdisplay_import;Pasword=<my_password>" /templatefile:"<my_path>"

Also, you can specify a password (for example, Password=root) in a *.dit data import template file as follows:

Code: Select all

...
  <TargetInfo>
    <PropertyValue Name="ConnectionName" xml:space="preserve">DBMSSQL\MSSQL2008R2</PropertyValue>
    <PropertyValue Name="ConnectionString" xml:space="preserve">Data Source=DBMSSQL\MSSQL2008R2;Integrated Security=False;User ID=sa;Password=root</PropertyValue>
    <PropertyValue Name="TargetTable" xml:space="preserve">AdventureWorks2008R2.dbo.AWBuildVersion</PropertyValue>
  </TargetInfo>
...

Please also see the 'How To: Import Data through Command Line' and 'Additonal /dataimport Arguments' topics in the product's Help documentation http://www.devart.com/dbforge/mysql/stu ... index.html

[ordnance1]

I tried altering the command string to include /connection but get an error "Invalid command line. The switch `/connection` has not been set or has been set incorrectly." and /connection is not in the list of available commands.

Code: Select all

les\Devart\dbForge Studio for MySQL\dbforgemysql" /dataimport /connection:"User Id=root;Host=localhost;Port=3306;Database=weatherdisplay_import;Pasword=<52150000>"/templatefile:"C:\wdisplay\webfiles\CustomTextOut.dit"
"C:\Program Files\Devart\dbForge Studio for MySQL\dbforgemysql" /dataimport /connection:"User Id=root;Host=localhost;Port=3306;Database=weatherdisplay_import;Pasword=<52150000>"/templatefile:"C:\wdisplay\webfiles\CustomTextOut2.dit"

[ordnance1]

As to altering the *.dit file. Here is the beginning of my *.dit file but I was unclear as to where to insert the password information.

<?xml version="1.0" encoding="utf-8"?>
<!-- Devart (www.devart.com), import template file-->
<!-- Modifying this generated file will probably render it invalid -->
<ImportTemplate FormatVersion="4">
<Format>Text</Format>
<FileSupport>True</FileSupport>
<PasswordSupport>False</PasswordSupport>
<TargetInfo>
<PropertyValue Name="ConnectionName" xml:space="preserve">MySQL56</PropertyValue>
<PropertyValue Name="ConnectionString" xml:space="preserve">User Id=root;Host=localhost;Database=weatherdisplay_import;Character Set=compatibility</PropertyValue>
<PropertyValue Name="TargetTable" xml:space="preserve">weatherdisplay_import.weatherhistorical</PropertyValue>
</TargetInfo>

[alexa]

Here is an example:

Code: Select all

"C:\Program Files\Devart\dbForge Studio for MySQL\dbforgemysql" /dataimport /connection:"User Id=root;Host=localhost;Port=3306;Database=weatherdisplay_import;Password=root" /templatefile

Also, please modify the following string:

Code: Select all

<PropertyValue Name="ConnectionString" xml:space="preserve">User Id=root;Host=localhost;Database=weatherdisplay_import;Character Set=compatibility</PropertyValue>

It has to look as follows:

Code: Select all

<PropertyValue Name="ConnectionString" xml:space="preserve">User Id=root;Host=localhost;Database=weatherdisplay_import;Character Set=compatibility;Password=root"</PropertyValue>