October DealsAmazon USOctober deal check: compare before you payAmazon US: current deals, useful picks and tech finds.Check DealsWindows FixRecommendedWindows errors stealing your time? Find the fix fastScan stability, cleanup and performance issues.Fix NowOctober DealsAmazon USDeal season is back - check today's better picksAmazon US: current deals, useful picks and tech finds.See Picks×
Skip to content
VGSources
Blog

How to Import an Existing Database Into Coolify

A complete Coolify database migration guide covering supported engines, dump formats, dashboard imports, CLI and API automation, destructive options, troubleshooting and post-restore verification.
Length9 min Posted Quest giverVGSources Team
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

To import an existing database into Coolify, first provision and start the destination database, prepare a dump compatible with its engine and version, stop application writes, and take a safety backup. Open the database’s Import Backup page, provide the dump by computer upload, absolute server path, or team S3 storage, review the detected format and generated command, select only the replacement or credential options your migration requires, and start the restore. Monitor the restore output, verify records and credentials, then reconnect the application and create a new backup.

What Coolify can import

Coolify’s built-in Import Backup workflow supports five destination engines. The dump format and scope must match the destination you created in Coolify.

As an Amazon Associate I earn from qualifying purchases.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Destination Accepted input Important scope or option
PostgreSQL SQL dumps, custom archives, tar archives, and all-database dumps Single-database and all-database restores are handled differently; owner and privilege restoration is optional.
MySQL SQL dumps, including all-database backups An all-database restore can include the mysql system database, users, passwords, and privileges.
MariaDB SQL dumps, including all-database backups The same user-and-privilege considerations apply as with MySQL.
MongoDB Archive files and dump directories The archive or directory must represent a MongoDB dump that the destination can restore.
SQLite A selected SQLite database file You choose the destination file under Restore into.

Redis, Dragonfly, KeyDB, and ClickHouse do not use this built-in Import Backup procedure. They require engine-specific export and restore steps instead.

Prepare the destination before importing

Provision and start the database

  1. Create the target database in Coolify with the engine and version required by the application.
  2. Wait until the database is running and reports healthy. Import cannot begin against a stopped destination.
  3. Confirm that the host has enough free storage for the uploaded or copied dump, temporary extraction files, and the restored data. Compressed inputs are detected before Coolify makes changes, but extraction still needs working space.

Match the engine, version, and dump format

A PostgreSQL dump is not interchangeable with a MySQL dump, and an archive produced for one restoration tool may not be accepted by another. Check the source engine, major version, database name, and whether the dump contains one database or every database on the source server before you start.

#1 Best Overall
Sale
Gaoye Blue Light Blocking Glasses
  • BLUE LIGHT BLOCKING GLASSES: Our blue light glasses for women boast UV400 protection, blocking harmful blue rays from computer screens. With these bluelight glasses women, you can enjoy gaming, reading, or watching TV with no worries of eye strain.
  • EYE RELIEF: Our blue light glasses are engineered to reduce blurry vision or strain caused by prolonged screen time. These womens blue light glasses aid in better sleep by preventing blue light from disrupting your natural sleep cycle, helping you fall asleep faster and enjoy a more restful night's sleep, making them the perfect christmas present.
  • COMFORTABLE: Crafted from durable material, our trendy blue light glasses for woman or blue light glasses men ensure long-lasting comfort. The high-transmittance lenses accessories, gamer gifts for men, help keep your eyes relaxed. Perfect stocking stuffers, gifts for gamers men, christmas gifts for men, halloween costumes.
  • LIGHTWEIGHT: These clear blue light glasses feature a lightweight frame, meaning they’ll stay comfy for long-term wear. Perfect as blue blockers glasses for women or mens blue light glasses, these non-prescription fake glasses for men can be worn throughout the day. The blue light blocking glasses women feature polycarbonate HD lenses, which are anti-reflective and restore true color.
  • WORRY-FREE PURCHASE: If you experience any issues, our support team is ready to assist you quickly. These are the perfect costume glasses for cosplay dressing up.

PostgreSQL custom archives are especially sensitive to major-version differences. Coolify’s default PostgreSQL workflow expects a pg_dump custom-format archive created with -Fc. For a migration from an older PostgreSQL major version, the documentation recommends a plain SQL or tar-format dump instead. Plain SQL must be restored with psql, not with the custom-archive restore path.

Create a PostgreSQL dump

A documented custom-format example is:

docker exec pg-db pg_dump -U postgres -d postgres -Fc > example-database.sql.gz

The command runs pg_dump inside the container named pg-db, connects as postgres, exports the database named postgres, and writes a custom-format archive to the host. Use the actual container, role, and database names from your installation. If the source and destination major versions are not compatible, use the plain or tar format recommended for that migration rather than relying on a custom archive.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Prepare MySQL or MariaDB data

Export a SQL dump that matches the destination engine. Decide whether the file represents one application database or all databases. An all-database backup can contain the mysql system database; restoring it can recreate users, passwords, and privileges and may invalidate the credentials Coolify saved for the target.

Prepare MongoDB and SQLite files

MongoDB imports accept a Mongo archive or a dump directory. Keep the directory structure intact if you use a directory source. For SQLite, identify the exact database file the application should use and the mounted path or file target that Coolify presents under Restore into.

Protect the application and the existing target

An import may replace objects, overwrite rows, or change credentials. Treat it as a migration window rather than a background copy.

  1. Put the application into maintenance mode or stop every process that can write to the database.
  2. Take a separate backup of the Coolify target immediately before the import. This gives you a rollback point if the dump is incomplete or the selected options are too destructive.
  3. Record the destination connection details, current Coolify credentials, health-check settings, and application environment variables.
  4. Check that no other restore, restart, or import is running. Coolify rejects a concurrent start, restart, or import while an operation is in progress.

Do not assume that a successful command means the application can reconnect. A restore can finish while the application still has an old password, points at a different SQLite file, or expects tables that were not included in a selected-database dump.

Free tools Windows power users keep installed

One-click scans. No signup required.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Rank #2
Windex Gaming Cleaning Wipes, Pre-Moistened Wipes to Instantly Clean all Gaming Gear and Electronics, Resealable Packaging for a Freshness Lock, 25 count (Pack of 1)
  • WINDEX GAMING WIPES: effortlessly clean all your gaming gear and gaming electronics in one easy step with our new Windex Gaming Wipes
  • AMMONIA FREE: our ammonia-free formula is safe to use on all of your favorite gaming equipment like consoles, headsets, controllers, screens, keyboards, and more
  • PRE-MOISTENED WIPES: each wipe instantly removes dust, dirt, and stubborn smudges and fingerprints leaving a streak-free shine
  • ANTI-STATIC: great for cleaning and wiping down your gaming gear and electronics leaving behind no visible residue
  • COMPACT RESEALABLE PACKAGE: store your pack of Windex Gaming Wipes anywhere in your home for whenever a quick and easy wipedown is needed

Import through the Coolify dashboard

1. Open the target’s Import Backup page

Open the running destination database in Coolify and select Import Backup. The page is available for standalone databases and for databases attached to a service stack.

2. Choose where the dump comes from

Coolify provides three source locations:

Source How it works Best fit
Upload from your computer Select the local dump in the browser and let Coolify upload it. A one-time migration when the file is on your workstation.
Absolute server path Enter the full path to a file already present on the database server, then select Check file. Large dumps already copied to the host, avoiding another browser upload.
Team S3 storage Choose team S3 storage, enter the object path, and select Check file. A dump shared through the team’s object storage or a repeatable migration process.

Use an absolute path rather than a relative filename. For S3, enter the object path exactly as it exists in the configured team storage. Checking the file lets Coolify inspect it before the restore begins.

3. Review what Coolify detected

Before starting, inspect the file information, detected backup format, and dump scope. Confirm whether Coolify identified a selected-database backup or an all-database backup. Read the generated import command as well; the command preview is read-only and shows the exact restore script Coolify will use.

If the detected format or scope is wrong, stop here. Re-export the source in a compatible format or select the correct file instead of trying to force a restore with mismatched options.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

4. Set destructive and credential options deliberately

The available controls depend on the engine and detected dump:

  • Replace objects that already exist: For a single-database PostgreSQL archive, this is off by default. Leave it off when existing objects must be preserved; enable it only when replacement is part of the migration plan.
  • Keep owners and privileges: This is off by default for PostgreSQL because roles from the source often do not exist on the destination. Enable it only after confirming that the required roles are present or that recreating them is intentional.
  • Restore users and privileges: For an all-database MySQL or MariaDB backup, this can restore the mysql system database, including users, passwords, and privileges. If you enable it, be prepared to update Coolify’s saved credentials and health checks afterward.
  • Restore into: For SQLite, select the target database file. This determines which mounted file the application will read after the import.

These defaults are conservative. They reduce accidental replacement, but they do not decide whether the source roles, users, or target file are correct for your application.

Rank #3
Sale
LISEN Cell Phone Stand Phone Holder for Desk, Office Decor Gadgets for Men
  • Ergonomic & Adjustable Design: Fight "text neck" and improve your posture. Designed for comfort, it offers an adjustable height (7.1in-8.5in) (1.4in adjustable range) and angle (5°-85°) Please note: cell phone stand is only 9 inches tall—the length of a standard pencil
  • Without blocking subtitles Perfect for office desk Tiktok Face Time Zoom video—this is the ultimate kitchen desk essential for phones! Perfect viewing experience while reducing neck back strain, A must-have for gamers streamers desk, and anyone who values both style and support!
  • Sleek & Stable Design fits Otterbox Case: Say goodbye to bent cables, tangles, and tip-overs! LISEN’s stylish adjustable desk phone holder features a built-in charging hole and smart cable management, keeping your phone secure and your workspace clutter-free cool gadgets for men
  • ANTI-SLIP DESIGN free hands: The under 10.00 items easy gadgets back and the bottom of this kitchen essentials for women are fully covered by anti-skid silicone, which LISEN stand up desk decor can provide maximum protection device from any scratches and slides
  • Your Perfect Viewing Companion:If your product arrives damaged or breaks within 365 days, reach out to LISEN for a quick and hassle-free solution. Struggling with assembly, like tightening the screw? We’ve got your back! Your experience matters to us. (Product including: phone Holder stand*1, screw*1, hexagon screwdriver*1, specification*1)

5. Start and monitor the restore

  1. Start the restore and complete Coolify’s confirmation prompt.
  2. Open Database Restore Output and follow the operation until it reports completion or an error.
  3. Do not restart the database, begin another import, or treat a closed browser tab as cancellation while the operation is running.

If the output reports an error, preserve the message and the generated command. Correct the format, path, permissions, credentials, or destination settings identified by the error, then restore the pre-import backup before attempting a new migration when the failed operation may have changed data.

Import from the CLI

The Coolify CLI can run the same workflow without the dashboard. A local file import uses:

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
coolify database import start <database-uuid> --file ./dump.sql.gz --wait

Replace <database-uuid> with the destination database UUID and the file path with the dump you prepared. The --wait option keeps the command attached until the import finishes, which is useful in a controlled migration window.

CLI sources can also come from a prior upload, configured S3 storage, or a server path. The important flags are:

  • --dump-all for an all-database dump.
  • --replace-existing when existing objects are intentionally replaced.
  • --keep-owners when PostgreSQL ownership and privileges should be retained.
  • --restore-mysql-users when an all-database MySQL or MariaDB restore should include users and privileges.
  • --sqlite-database to select the SQLite database file that receives the restore.

Databases deployed inside a service stack use the corresponding service-database import command rather than the standalone database command. Apply the same compatibility, backup, and verification checks when automating the operation.

What’s actually slowing this PC down?

Pick the symptom - the matching free tool is one click away.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Automate imports through the API

The API separates uploading, starting, and checking an import. For a standalone database, use these endpoints:

Rank #4
Ledagic IC+RGBW USB Powered Led Light Bar with App & Remote Control, 2 Pack
  • Easy Installation: Our gaming lights have been designed to enhance your entertainment experience. Simply position the led light bar next to your TV or game console to create a game room environment with ease. They come with USB power and a 60 inch cord for direct mounting and mobility
  • Audio Syncing & Extensive Mode: The built-in high-sensitivity music sensor allows you to sync the TV led lights to your favorite music. Lights react and move to the beat of music, film and game audio, creating an incredible immersive sound and light experience – and all without the need for an additional hub. You can choose from 64+ patterns, including strobe, illusion, jump, energy, gradient, running, chasing, fluttering mode etc. Each mode can be applied to different scenes
  • 64+ Chasing IC+RGB & W Effect: The independent control design of IC+RGB and white all-in-one multifunctional rgbw led bar lights monitor backlight allows you to easily switch the led lights for desk between IC+RGB and white to enjoy a variety of lighting effects, you can choose white lighting mode with high brightness for better illumination when working, etc. Choose IC+RGB lighting mode when you need to create an entertaining atmosphere for the light show, 16 million colours of Color changing rgb light bar let you dance to the beat and create a dynamic party atmosphere
  • Dynamic and Dimmable Lights: 1%-full brightness free brightness adjustment gives you the flexibility to adjust dimmable led light bar for room decorations or a variety of occasions
  • USB Powered: USB light bars for room can be powered by powernank, usb charger, TV, Monitor, laptop PC mainframe, making behind TV led lighting bar easy to install in any location.TV led lights are powered by the TV usb interface / PC mainframe, can be turned on/off synchronously with TV / PC
Purpose Endpoint
Upload a dump POST /databases/{uuid}/imports/uploads
Start the import POST /databases/{uuid}/imports
Read import status GET /databases/{uuid}/imports/{activity_id}

For a database belonging to a service, use the same suffixes under:

/services/{uuid}/databases/{database_uuid}/imports

Upload and start operations require the write permission. A server-path import also requires deploy. After starting, poll the returned activity ID and do not reconnect application writers until the status and database checks are successful.

Verify the restored database before cutover

Use a separate validation pass before taking the application out of maintenance mode.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
  • Confirm that the Coolify database is running and healthy, and review its logs for restore warnings.
  • Connect with a database client using the credentials the application will use.
  • Inspect schemas and tables for PostgreSQL, MySQL, and MariaDB; inspect collections for MongoDB.
  • Query representative records, including recently changed records and any tables the application needs at startup.
  • For SQLite, verify that the application reads the file selected under Restore into and that the mounted path is the one configured in the application.
  • If users or passwords were restored, update Coolify’s saved credentials, environment variables, and health checks before testing the application.
  • Run an application-level smoke test: log in, read existing content, create a test record if appropriate, and confirm background jobs can connect.

Only after these checks should you resume normal writes. Once the application is working against the imported data, create a fresh backup of the restored target so the new state has its own recovery point.

Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

Common failure points and the safest response

The file is rejected or detected as the wrong format

Check the source engine and export tool first. A PostgreSQL plain SQL file, custom archive, and tar archive require different restore commands. Re-export in a format supported by the destination and, for PostgreSQL major-version migrations, prefer plain or tar format when the custom archive is not version-compatible.

The restore runs out of disk space

Check free space on the Coolify host, including room for the source file and temporary extraction. Remove or relocate unrelated files, increase the available volume, or place the dump in a storage location that does not consume the database volume. Do not delete the pre-import safety backup until the migration is verified.

Best Value
Sale
HUANUO FlowLift™ Dual Monitor Stand, Fully Adjustable Gaming Monitor Desk Mount for 13–32″ Computer Screens, Full Motion VESA 75x75/100x100 with C-Clamp & Grommet Base, Each Arm Holds 4.4 to 19.8 lbs
  • Compatible with Wide Screens - To ensure compatibility with the dual monitor mount, your each monitor must meet three conditions at the same time: First, computer screens size range: 13 to 32 inches. Second, screen weight range: 4.4 to 19.8 lbs. Third, the back of the monitor screen must have VESA mounting holes with a pitch of 75x75mm or 100x100mm.
  • Regarding the compatibility with desks - Your desk must meet three conditions at the same time: First, desk material: Only wooden desks are recommended, plastic or glass desks cannot be used. Second, desk thickness range: 0.59" - 3.54". Third, the bottom of the desk should not have any cross beams or panels, as this will interfere with installation. We recommend carefully checking that your desk and monitors meets all above conditions before purchasing.
  • Dual C-Clamp Hold - Worried your dual monitors might wobble or slip? Our upgraded base uses a larger platform plus a dual C-clamp structure to lock the dual monitor arm firmly to your desk. Each arm safely keeps your screens steady while you type, click and game—no shaking, no sliding, just a clean and secure setup you can trust every day. It also provides Grommet Mounting installation choice, both options ensure stable and secure fixation for your 0.59" - 3.54" desk.
  • Full-Motion Adjustment For Comfortable View - Pull the screen closer when you’re deep in a spreadsheet, push it back to watch videos, or rotate to portrait for coding — moving everything smoothly with just one hand. The monitor stand offers +85°/-50° tilt, ±90° swivel and 360° rotation. Raise your monitor up to 15.75″ to support a healthy sitting posture. Whether you’re working from home, gaming through the night, or switching between video calls and documents, getting the screens to your natural line of sight helps relieve neck, shoulder and back strain so you can stay focused longer with less fatigue.
  • Keep Your Desk Organized: By lifting both screens off the desktop, this dual monitor stand opens up valuable space for your keyboard, notebook, docking station or a simple, clutter-free work area. Built-in cable management guides wires along the arms, keeping cords out of sight and out of the way. Enjoy a tidy, modern workstation that looks as good as it feels to use.

PostgreSQL ownership or privilege errors appear

Source roles may not exist in the destination. Retry with owner and privilege retention disabled, or create and map the required roles deliberately before importing. Do not enable Keep owners and privileges merely to silence an error if those roles are not part of the destination design.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

The application cannot log in after a MySQL or MariaDB restore

An all-database restore with user restoration can replace the mysql system database and therefore change passwords and privileges. Update Coolify’s stored credentials, application environment variables, and health checks to match the restored accounts, then test a fresh connection.

The import appears stuck or another operation is blocked

Check Database Restore Output and the database logs before taking action. Coolify prevents a concurrent start, restart, or import while one operation is active. Wait for the current activity to finish or fail; do not launch a second restore against the same target.

Importing application data is not the same as restoring Coolify

Coolify’s own control-plane restore is a separate operation. Restoring a self-hosted Coolify instance brings back projects, resources, settings, saved credentials, and deployment history, but it does not restore data stored inside application databases, services, or volumes. Those data stores require their own database import or volume-restore procedure.

Therefore, restoring the Coolify control plane alone will not repopulate an application’s PostgreSQL, MySQL, MariaDB, MongoDB, or SQLite data. Keep the application backup and the Coolify instance backup as separate recovery assets, and test each restoration path independently.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

A practical migration sequence

  1. Identify the source engine, version, database scope, dump format, and credentials.
  2. Provision and start the matching destination database in Coolify.
  3. Confirm free disk space and copy or upload the dump.
  4. Stop application writes and take a backup of the empty or existing destination.
  5. Open Import Backup, select upload, server path, or team S3, and check the file.
  6. Review detected format, scope, and the read-only generated command.
  7. Choose replacement, ownership, user-restoration, or SQLite-target options only when they match the migration plan.
  8. Start the restore and monitor Database Restore Output to completion.
  9. Validate health, schemas or collections, representative records, credentials, and application connectivity.
  10. Resume writes and create a new backup of the verified destination.

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.

Leave a Reply

Your email address will not be published. Required fields are marked *

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

More quests from Patch Notes

  1. How to Set Up a RedM (RDR2) Server in 2026: License Key, txAdmin and server.cfg, Step by StepBlog11min
  2. Best RedM (RDR2) Server Hosting in 2026: Comparing Four Hosts on Slots, Memory and PriceBlog10min
  3. How to Host a Mindustry Server in 2026: server-release.jar, Port 6567 and the Commands That MatterBlog7min
Recommended PC Tool
Recommended PC Tool
Windows Errors? Fix Them Before They SpreadFree repair scan
Crashes, No Sound, or Screen Glitches?Free driver scan

Two free Windows tools

One Free Minute Could Fix That PC

Before you go - each of these free tools takes about a minute and tackles what quietly slows a Windows PC down.

Special offer. View Outbyte info, uninstall instructions, EULA, and Privacy Policy.