One database every day (1), Database (

One database every day (1), Database (

Connect to the database:

mysql -uroot -p

Enter the Database Password to log on.

View mysql version information:

mysql> select version();+-------------------------+| version()               |+-------------------------+| 5.7.20-0ubuntu0.17.04.1 |+-------------------------+1 row in set (0.00 sec)

View the current time:

mysql> select now();+---------------------+| now()               |+---------------------+| 2017-11-09 23:27:41 |+---------------------+1 row in set (0.01 sec)

Implements file transfer between Windows and Ubuntu virtual machines.

In fact, it is easy to install a VMware tools.

Open file management and there is a VM tar package. If there is no tar package, you need to mount a cd drive.

Right-click, set,

I have two cd drives, one for Ubuntu and the other for VM installation. Copy the tar package to the desktop to extract the file.

tar -xzvf  VMwareTools-10.0.6-3595377.tar.gz

Switch to the decompressed directory and execute:

sudo ./wmware-install.pl

Press enter. However, I cannot drag files after installation, so I have to use lrzsz.

sudo apt install lrzsz

Upload successful.

Data Transfer Method

When the machine is changed (or after the dual system is installed), you need to import the previous database information.

Step 1: store the database information to the physical hard disk.

C:\Users\jeffd>mysqldump -uroot -p dbsys > D:\dbsys.sqlEnter password: ********

The database file is generated in the corresponding path.

Create a new database on the machine to be transferred.

Mysql-uroot-p database name <D: \ dbsys. SQL

The database is imported successfully.