We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
from ''MyISAM'' to ''InnoDB'' and conversely
from ''MyISAM'' to ''InnoDB'' and conversely
Hello,
How i can change ''MyISAM'' to ''InnoDB'' ?
and conversely ?
Thanks.
How i can change ''MyISAM'' to ''InnoDB'' ?
and conversely ?
Thanks.
Re: from ''MyISAM'' to ''InnoDB'' and conversely
mysql / phpmyadmin - http://dev.mysql.com/doc/refman/5.6/en/ ... nnodb.html
or magic php scripts (source)
or magic php scripts (source)
Code: Select all
<?php
// connect your database here first
//
// Actual code starts here
$sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'your_database_name'
AND ENGINE = 'MyISAM'";
$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{
$tbl = $row[0];
$sql = "ALTER TABLE `$tbl` ENGINE=INNODB";
mysql_query($sql);
}
?>
Re: from ''MyISAM'' to ''InnoDB'' and conversely
Hello,skurudo wrote:mysql / phpmyadmin - http://dev.mysql.com/doc/refman/5.6/en/ ... nnodb.html
or magic php scripts (source)Code: Select all
<?php // connect your database here first // // Actual code starts here $sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'your_database_name' AND ENGINE = 'MyISAM'"; $rs = mysql_query($sql); while($row = mysql_fetch_array($rs)) { $tbl = $row[0]; $sql = "ALTER TABLE `$tbl` ENGINE=INNODB"; mysql_query($sql); } ?>
this script:
Code: Select all
<?php
// connect your database here first
//
// Actual code starts here
$sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'your_database_name'
AND ENGINE = 'MyISAM'";
$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{
$tbl = $row[0];
$sql = "ALTER TABLE `$tbl` ENGINE=INNODB";
mysql_query($sql);
}
?>
I don't know what all i need edit in this code,
can you pls tell what i need to edit in code, my database name is ''auto_db'' ?
Thanks.
Re: from ''MyISAM'' to ''InnoDB'' and conversely
Too many manuals in network, make backup and try:
https://gist.github.com/calevans/9943627
https://pantheon.io/blog/moving-mysql-t ... sam-innodb
http://www.woblag.com/2012/10/batch-con ... nnodb.html
https://gist.github.com/calevans/9943627
https://pantheon.io/blog/moving-mysql-t ... sam-innodb
http://www.woblag.com/2012/10/batch-con ... nnodb.html