• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

MySQL DB backup

A

adrian5b

New Member
Joined
May 17, 2009
Messages
15
Reaction score
0
Hello, I'm changing from one host to another since they're gonna charge me less money and offer me more RAM memory. Anyway, the problem is that I don't want to lose the players I already have in my server. I've been looking for a tutorial for how to backup a MySQL database here in the forums of OtLand and found nothing, I don't know if there's such a tutorial or if I'm not searching well enough. Could anyone help me with this, perhaps posting the link to an OtLand tutorial?

PS: I already tried MySQL database backup tutorials looking for Google for any database, but some specific OT database problems popped up, that's why I need a really specific tutorial.
 
Sort by date Sort by votes
Ya Im having this problem when IMPORTING the database with all the players on to the new server.
PHP: 
Error
Parece haber un error en su consulta de SQL. La salida generada por el servidor de MySQL, de existir, aparece abajo, en cuyo caso puede ayudar a diagnosticar el problema.

ERROR: Signo de puntuación desconocido @ 5
STR: />
SQL: <br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br />
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost:3306
-- Tiempo de generación: 26-05-2009 a las 02:46:36
-- Versión del servidor: 5.0.37
-- Versión de PHP: 5.0.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

consulta SQL:

<br /> <b>Warning</b>: parse_url(https:///domains/databases/phpMyAdmin/) [<a href='function.parse-url?phpMyAdmin=7415243300d923d7ba48bb358890f290'>function.parse-url</a>]: Unable to parse url in <b>C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php</b> on line <b>244</b><br /> -- phpMyAdmin SQL Dump -- version 2.10.1 -- http://www.phpmyadmin.net -- -- Servidor: localhost:3306 -- Tiempo de generación: 26-05-2009 a las 02:46:36 -- Versión del servidor: 5.0.37 -- Versión de PHP: 5.0.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

MySQL ha dicho: 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<br />
<b>Warning</b>:  parse_url(https:///domains/databases/phpMyAdmin/) [<a hr' at line 1
 
Upvote 0 Downvote

Similar threads

R
  • Question
Error when opening tfs 1.4
Replies
9
Views
588
Djivar
Djivar
Duzo
  • Solved
Zone ACC Version 1.5 Can't Register Account. TFS 1.0
Replies
6
Views
922
kibo433
K
Epsilons
  • Question
OTClient Stuck on "Please wait : Connecting to login server" (ERROR: got a network message with invalid checksum)
Replies
10
Views
844
Epsilons
Epsilons
DaMaoKaiz
  • Question
OT Server setup issues
Replies
0
Views
352
DaMaoKaiz
DaMaoKaiz
alelu541
  • Question
AAC AAC not connecting with my SQL
Replies
1
Views
383
slaw
slaw
Back
Top