Just a quick point on the above which I forgot to post. IF you can, it will be best to use mysqldump to dump the database into a .sql file on the first server, then move or download it to the next server or localhost. This will help maintain the consistency of the database. Moving the database files without using the dump can cause structural issues in the database with the ibdata, ibdata1 files. This can cause tables not to show. Use the mysqldump syntax shown below if you can access your server with root access.
$ mysqldump -u root -p *database-name* > *sqlbackupname*.sql
$ Enter mysql password: *your-mysql-password*
The above will create a database dump(backup) to a file called *sqlbackupname*.sql.
Then open your next server or your localhost and type the below to restore the database onto the server you want to move to:
$ mysql -u root -p *database-you-want-to-restore-to* < *sqlbackupname*.sql
I hope this helps someone in the future.
$ mysqldump -u root -p *database-name* > *sqlbackupname*.sql
$ Enter mysql password: *your-mysql-password*
The above will create a database dump(backup) to a file called *sqlbackupname*.sql.
Then open your next server or your localhost and type the below to restore the database onto the server you want to move to:
$ mysql -u root -p *database-you-want-to-restore-to* < *sqlbackupname*.sql
I hope this helps someone in the future.
