Many games for your gameserver use databases to store long-term data and function properly. Some games, resources, or mods provide you with a .sql file that you can use to import the corresponding tables and data into your own database. Exporting your database is also useful for transferring data between systems or simply creating manual backups of your files. In this guide, we'll show you how to import SQL files into your gameserver database or export them from it using the phpMyAdmin interface.
Gameserver: Import or Export an SQL File
Learn how to manage your gameserver database efficiently by importing and exporting SQL files with phpMyAdmin → Find out more
10 November 20262 min read0 Views0 helpful
FAQ
Frequently asked questions
Use the phpMyAdmin interface, which you can open by clicking the blue link button in the Databases tab of your gameserver.
The maximum file size is 2 MB. If your file is larger, use an SQL splitter such as the Pinetools SQL Splitter to divide it into smaller parts, then import each part separately.
Look for
USE xxx or CREATE DATABASE in the file. These commands can conflict with the automatically assigned ZAP ID database name, so remove them and save the file before importing it.Select the main database (your ZAP ID), click Export at the top, then choose Quick to export all tables and data or Custom to select specific ones. Finally, click Export.
Feedback
Was this article helpful?
Your feedback helps us prioritize and improve content.
0 of 0 Users found this article helpful.
Personal support
Need more help than the guide provides?
Our ZAP support team knows your product — briefly describe your issue and we'll help you personally.
Preferred source on Google
