• 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!

How to make a Server online (8.60)

mimsol

New Member
Joined
Mar 18, 2020
Messages
83
Reaction score
2
i have the following problem
i set up a server
an website via (xamp)
an database in phpmyadmin
and now i want to play it with some friends online and i really dont know how to make this server online
i tryed already an tutorial
with port forwarding but i dont know what to type there because every viedeo have other router settings
it would be nice if someone can send me a link or whatever helps me
if needed
RouterModel (TC270) Technic.
 
so for example
109.125.95.177 exivia.hopto.org

192.168.0.25 exivia.hopto.org

thats right ?=
Post automatically merged:

i need to restart pc after this ?
Post automatically merged:

InnoDB: using atomic writes.
2020-08-08 0:37:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-08-08 0:37:58 0 [Note] InnoDB: Uses event mutexes
2020-08-08 0:37:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-08-08 0:37:58 0 [Note] InnoDB: Number of pools: 1
2020-08-08 0:37:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-08-08 0:37:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-08-08 0:37:58 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-08 0:37:58 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2020-08-08 0:37:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-08-08 0:37:59 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-08-08 0:37:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-08-08 0:37:59 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-08-08 0:37:59 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-08-08 0:37:59 0 [Note] InnoDB: Waiting for purge to start
2020-08-08 0:37:59 0 [Note] InnoDB: 10.4.13 started; log sequence number 300297; transaction id 171
2020-08-08 0:37:59 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-08-08 0:37:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-08-08 0:37:59 0 [Note] InnoDB: Buffer pool(s) load completed at 200808 0:37:59
2020-08-08 0:37:59 0 [Note] Server socket created on IP: '::'.
2020-08-08 1:13:13 0 [ERROR] mysqld.exe: Index for table '.\mysql\db' is corrupt; try to repair it

***WARNING: .\mysql\db could not be opened: Error: 126
2020-08-08 1:13:13 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 11% 24% 35% 68% 88% 100% (0.0 seconds); tables to flush: 1 0
(0.0 seconds);
2020-08-08 1:13:13 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2020-08-08 1:13:13 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-08-08 1:13:13 0 [Note] InnoDB: Uses event mutexes
2020-08-08 1:13:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-08-08 1:13:13 0 [Note] InnoDB: Number of pools: 1
2020-08-08 1:13:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-08-08 1:13:13 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-08-08 1:13:13 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-08 1:13:13 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=865626
2020-08-08 1:13:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-08-08 1:13:13 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-08-08 1:13:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-08-08 1:13:13 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-08-08 1:13:13 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-08-08 1:13:13 0 [Note] InnoDB: Waiting for purge to start
2020-08-08 1:13:13 0 [Note] InnoDB: 10.4.13 started; log sequence number 865635; transaction id 1301
2020-08-08 1:13:13 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-08-08 1:13:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-08-08 1:13:14 0 [Note] Server socket created on IP: '::'.
2020-08-08 1:13:14 0 [Note] InnoDB: Buffer pool(s) load completed at 200808 1:13:14
InnoDB: using atomic writes.
2020-08-08 1:13:27 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-08-08 1:13:27 0 [Note] InnoDB: Uses event mutexes
2020-08-08 1:13:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-08-08 1:13:27 0 [Note] InnoDB: Number of pools: 1
2020-08-08 1:13:27 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-08-08 1:13:27 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-08-08 1:13:27 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-08 1:13:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-08-08 1:13:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-08-08 1:13:27 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-08-08 1:13:27 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-08-08 1:13:27 0 [Note] InnoDB: Waiting for purge to start
2020-08-08 1:13:28 0 [Note] InnoDB: 10.4.13 started; log sequence number 865644; transaction id 1301
2020-08-08 1:13:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-08-08 1:13:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-08-08 1:13:28 0 [Note] Server socket created on IP: '::'.
2020-08-08 1:13:28 0 [Note] InnoDB: Buffer pool(s) load completed at 200808 1:13:28
InnoDB: using atomic writes.
2020-08-08 1:14:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-08-08 1:14:26 0 [Note] InnoDB: Uses event mutexes
2020-08-08 1:14:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-08-08 1:14:26 0 [Note] InnoDB: Number of pools: 1
2020-08-08 1:14:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-08-08 1:14:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-08-08 1:14:26 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-08 1:14:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-08-08 1:14:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-08-08 1:14:26 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-08-08 1:14:26 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-08-08 1:14:26 0 [Note] InnoDB: Waiting for purge to start
2020-08-08 1:14:27 0 [Note] InnoDB: 10.4.13 started; log sequence number 865653; transaction id 1301
2020-08-08 1:14:27 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-08-08 1:14:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-08-08 1:14:27 0 [Note] Server socket created on IP: '::'.
2020-08-08 1:14:27 0 [Note] InnoDB: Buffer pool(s) load completed at 200808 1:14:27
2020-08-08 1:14:27 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and should be repaired
2020-08-08 1:14:27 0 [ERROR] mysqld.exe: Index for table '.\mysql\db' is corrupt; try to repair it
2020-08-08 1:14:27 0 [ERROR] Couldn't repair table: mysql.db
2020-08-08 1:14:27 0 [ERROR] Fatal error: Can't open and lock privilege tables: Index for table 'db' is corrupt; try to repair it
2020-08-08 1:14:27 0 [ERROR] Aborting
InnoDB: using atomic writes.
2020-08-08 1:15:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-08-08 1:15:01 0 [Note] InnoDB: Uses event mutexes
2020-08-08 1:15:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-08-08 1:15:01 0 [Note] InnoDB: Number of pools: 1
2020-08-08 1:15:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-08-08 1:15:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-08-08 1:15:01 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-08 1:15:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-08-08 1:15:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-08-08 1:15:01 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-08-08 1:15:01 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-08-08 1:15:01 0 [Note] InnoDB: Waiting for purge to start
2020-08-08 1:15:01 0 [Note] InnoDB: 10.4.13 started; log sequence number 865662; transaction id 1301
2020-08-08 1:15:01 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-08-08 1:15:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-08-08 1:15:01 0 [Note] Server socket created on IP: '::'.
2020-08-08 1:15:01 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and should be repaired
2020-08-08 1:15:01 0 [Note] InnoDB: Buffer pool(s) load completed at 200808 1:15:01
2020-08-08 1:15:01 0 [ERROR] mysqld.exe: Index for table '.\mysql\db' is corrupt; try to repair it
2020-08-08 1:15:01 0 [ERROR] Couldn't repair table: mysql.db
2020-08-08 1:15:01 0 [ERROR] Fatal error: Can't open and lock privilege tables: Index for table 'db' is corrupt; try to repair it
2020-08-08 1:15:01 0 [ERROR] Aborting
InnoDB: using atomic writes.
2020-08-08 1:15:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-08-08 1:15:09 0 [Note] InnoDB: Uses event mutexes
2020-08-08 1:15:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-08-08 1:15:09 0 [Note] InnoDB: Number of pools: 1
2020-08-08 1:15:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-08-08 1:15:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-08-08 1:15:09 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-08 1:15:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-08-08 1:15:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-08-08 1:15:09 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-08-08 1:15:09 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-08-08 1:15:09 0 [Note] InnoDB: Waiting for purge to start
2020-08-08 1:15:09 0 [Note] InnoDB: 10.4.13 started; log sequence number 865671; transaction id 1301
2020-08-08 1:15:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-08-08 1:15:09 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-08-08 1:15:09 0 [Note] Server socket created on IP: '::'.
2020-08-08 1:15:09 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and should be repaired
2020-08-08 1:15:09 0 [Note] InnoDB: Buffer pool(s) load completed at 200808 1:15:09
2020-08-08 1:15:09 0 [ERROR] mysqld.exe: Index for table '.\mysql\db' is corrupt; try to repair it
2020-08-08 1:15:09 0 [ERROR] Couldn't repair table: mysql.db
2020-08-08 1:15:09 0 [ERROR] Fatal error: Can't open and lock privilege tables: Index for table 'db' is corrupt; try to repair it
2020-08-08 1:15:09 0 [ERROR] Aborting
Post automatically merged:

now i cant run mysql :D
why is that so hard to open a server XD
 
Last edited:
You must have missed a step in the tutorial or didn't follow it correctly, Try re-installing your uniform server or XAMPP.
 
I helped through DM/Teamviewer and he got everything running properly now AAC/Server.
 
Solution
Back
Top