<div>
See if the below article answers your questions.<br />
<a href="http://dbaspot.com/forums/mysql/371033-mysqldump-view-definitions.html" rel="ugc">http://dbaspot.com/forums/mysql/371033-mysqldump-view-definitions.html</a><br />
<br />
Do the two servers have a continuous dedicated connection where you can define one as a slave replica to the other??<br />
Check the end of the dump file to see whether there are alter table to view statements.<br />
<br />
Which version of mysql server and mysql utils are you using?<br />
<br />
<br />

</div>


See if the below article answers your questions.
http://dbaspot.com/forums/mysql/371033-mysqldump-view-definitions.html [http://dbaspot.com/forums/mysql/371033-mysqldump-view-definitions.html]

Do the two servers have a continuous dedicated connection where you can define one as a slave replica to the other??
Check the end of the dump file to see whether there are alter table to view statements.

Which version of mysql server and mysql utils are you using?




<div>
If both servers have the same mysql version what you can do is sync the content of the database from your server A to server B.<br />
<br />
Something like:<br />
<br />
rsync -av yourdatabase/ yournewserver/database/
</div>


If both servers have the same mysql version what you can do is sync the content of the database from your server A to server B.

Something like:

rsync -av yourdatabase/ yournewserver/database/

<div>
None of the offered solutions resolved our need.
</div>


None of the offered solutions resolved our need.

<div>
<div class="content wysiwyg-content">
MySQL newbie here just wondering if this is expected behavior or not.<br />
<br />
Essentially needed to create a mirrored instance of an existing MySQL database. Ran a full mysqldump, moved the dump file to the new server and imported everything just via mysql &lt;&nbsp;dumpfile.<br />
<br />
Now, according to those working with the data, all views have become regular tables. Is this standard? Is there a way to create the dump file (or a way to import it) to ensure that this doesn't happen?<br />
<br />
Thanks in advance, SQL wizards!
</div>
</div>


MySQL newbie here just wondering if this is expected behavior or not.

Essentially needed to create a mirrored instance of an existing MySQL database. Ran a full mysqldump, moved the dump file to the new server and imported everything just via mysql < dumpfile.

Now, according to those working with the data, all views have become regular tables. Is this standard? Is there a way to create the dump file (or a way to import it) to ensure that this doesn't happen?

Thanks in advance, SQL wizards!

After MySQL dump and import into new instance, all views now tables.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.