Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
Website website #website HTML/CSS #help
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
Website website #website HTML/CSS #help
About this forum
  1. Website Builder
  2. Forum

Moving database to other server - some website images do not display

Subscribe

Get notified when there's activity on this post

This question has been flagged
imagemoveurl
2 Replies
4173 Views
Avatar
Raf Frederickx

Hi

I want to move a database with a website to another server and run the website from that machine.  I'm developing the webiste on the old server, but at a given point, I want to transfer it to the real server and domain and continue there.  So, I've taken a backup of the old one and restored it on the new one.

If I then connect to the new machine via the browser, it turns out that certain images (like background images in caroussels and some others, mostly coming from Unsplash) are not displaying.  Some others are displaying fine and are also coming from Unsplash (e.g. cards with a picture). 

When looking at the source view, it displays the url of the original server (external ip address).  If that old machine is still running, the images on the new one are coming through, since the source is still available; as soon as I turn the old machine off, the images on the new machine are gone and also the new server seems to respond much more slowly.  It's looking for these pics and can't find them.

Now, how can I solve this?  After doing a backup on the old machine and then a restore on the new one, 

Is there a simple way to replace all the <old url> references to the <new url> reference?  Or can I avoid that, when uploading images (from Unsplash), it uses the full url instead of simply putting /web/image/…?  Strange that some image sources are showing the full path and some aren't.  The former are creating the issue in my case.

Any ideas, anyone?

Thanks.

0
Avatar
Discard
Vasil Stoev

Hi,

If you can open the back up in a text editor you can search and replace the IP address.

Avatar
Vasil Stoev
Best Answer

Hi Raf,

As I can see the encryption is on the filens store locally but not the address. You should have 2 files and one folder in to the backup zip. The dump.sql file contain the database data. If you search for a filename there you can see where is stored. If you have external source for the image the address should be there.

File from url:



Locally stored file:



* I couldn't add second answer :( in which to add pictures. Can't add pictures to comments :( So I convert answer to comment which deleted your comment  :( -

Thanks, Vasil.

Opened the zip file and everything returned was sort of encrypted.

Looking for numbers (ip addresses) will work, but what about looking for an actual domain?

Because of the encryption, you won't be able to find something like \azure.com.

Any other ideas?

Thanks.

1
Avatar
Discard
Raf Frederickx
Author

Thanks, again, Vasil.

So, I could basically edit the dump.sql and replace the old address into the new one and save; then restore that zip? Haven't tried this, but I'll take your word for it.

Vasil Stoev

Yes that should work. Just in case create a copy of your original backup so you can restore if anything goes wrong.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
TypeError: Cannot read properties of undefined (reading 'url')
image url
Avatar
Avatar
Avatar
2
Jul 22
12943
Contact image via url Solved
image url odoo11.0
Avatar
Avatar
Avatar
2
Sep 21
8953
IMPORT URL IMAGE CSV TO IMAGE ARTICLE IN ODOO Solved
import image url
Avatar
Avatar
Avatar
3
Jul 20
11308
Add an image URL on Media center and save to server file system.
image filestore url media
Avatar
0
Jun 23
6086
How to get the url of a fields.Binary with attachment=True Solved
attachment image url binaryfield
Avatar
Avatar
Avatar
3
May 23
25814
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now