Testlink upgrade got issue "You need to proceed with Manual upgrade of your DB scheme to DB 1.9.15"
<p>I'm using xampp to handle php, mysql and apahce. The older version xampp is using the MySQL, and the latest version is using the MariaDB. I'm upgrade xampp and testlink as below:</p>
<ol>
<li>In older version xampp (v5.6.8), <code># mysqldump -u root -p testlink &gt; ~/backup.sql</code></li>
<li>Stop the lampp service and backup order version lampp: <code># mv /opt/lampp /opt/lampp.bak</code></li>
<li>Install new version <a href="https://downloadsapachefriends.global.ssl.fastly.net/xampp-files/5.6.24/xampp-linux-x64-5.6.24-1-installer.run?from_af=true" rel="nofollow noreferrer">lampp-linux v5.6.24-1.run</a></li>
<li>Download and install the latest verion testlink (v1.9.15) to <code>/opt/lampp/htdocs/testlink</code></li>
<li>Update couple of configuration files, so http://localhost/phpmyadmin can be visited</li>
<li>http://localhost/testlink/install/default.php to start a <strong>new install</strong>, after that, http://localhost/testlink can be visit and also login by admin.</li>
<li>restore the mysql data which has been dumpped in step 1： <code># mysql -u root -p testlink &lt; ~/backup.sql</code></li>
</ol>
<p>Then http://localhost/testlink/login.php shows:</p>
<blockquote>
<p>You need to proceed with Manual upgrade of your DB scheme to DB 1.9.15</p>
<ul>
<li>Read README file!</li>
</ul>
</blockquote>
<p>I've also checked the http://localhost/testlink/README:</p>
<blockquote>
<ul>
<li>Upgrade from 1.9.14 to 1.9.15 WARNING: if you are using a table prefix replace /<em>prefix</em>/ with your prefix</li>
</ul>
<p>a) Execute
install/sql/alter_tables/1.9.15/&lt;your_db&gt;/DB.1.9.15/step1/db_schema_update.sql</p>
<p>b) Execute (IF EXISTS)
install/sql/alter_tables/1.9.15/&lt;your_db&gt;/DB.1.9.15/stepZ/z_final_step.sql</p>
</blockquote>
<p>But I don't know how to <strong>execute</strong> a sql script in commandline.</p>
<p>====</p>
<ul>
<li>I'm tried to use <code># mysql_update -u root -p</code> to update the database,
but looks like nothing changed.</li>
<li>I've also import dump sql file by force way: <code># mysql -u root -p --force testlink &lt; ~/backup.sql</code>, but nothing changes also.</li>
</ul>
<p>Can anyone help me?</p>