import

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
call
Forum Newbie
Posts: 10
Joined: Thu Mar 18, 2004 12:15 am
Location: india

import

Post by call »

how can I import dabase from a remote server in MySql?
Can anybody hepl me? :?:
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post by JayBird »

Posting Guidelines

In a nutshell:
  1. Try a search first - Google, the PHP manual, the MySQL manual, Phuse and this forum are all good resources.
  2. Read the tutorials - they're not there for nothing and cover some frequently asked questions.
  3. If you're looking for a script to do something in particular and have no wish to write your own please either go to hotscripts.com or advertise the job in the Job Hunt forum.
  4. Read the forum descriptions carefully, you want to post your question in the most relevant one.
  5. Do not hijack other people's threads, post your own topic and reference (i.e. link to) the other thread in it.
  6. Write your question carefully, think about what you need to achieve and exactly what help you are looking for.
  7. Write a clear subject line, it'll help people deciding whether to look at your post or not - 'help, PHP noob' is probably going to be ignored by some.
  8. Don't just post - 'This doesn't work' - tell us exactly what doesn't work and make sure to include any error messages you're getting.
  9. Use the bbcode tags for code blocks - for PHP code use the tags to enclose it, for all other code use the tags - this will make it much easier for people to read your code (especially if you've taken the time to indent it properly).
  10. Don't cross-post, once you've chosen the most relevant forum there is no need to post the same question in any of the others.
  11. Remember all the people here answering questions are volunteers, be polite to them, thank them for their help and if you aren't getting the answers you want refine your question don't have a go at the people trying to help you.
  12. If you work out the answer yourself post the solution - it'll help the next person who comes along with a similar question.
  13. If the solution someone else gives you works, post back and say so - it's always nice to know that a problem's fixed.

Does your question meet requirement 6?????????????????????

Think about it!

Mark
coreycollins
Forum Commoner
Posts: 67
Joined: Sun Feb 01, 2004 1:04 pm
Location: Michigan

Post by coreycollins »

I'll answer his question a little more nicely. We need more information. Reading what you wrote I'm going to suggest maybe backing up the database at one location and restoring it in another. Let me know if this helps if not we're going to need more information.
User avatar
AVATAr
Forum Regular
Posts: 524
Joined: Tue Jul 16, 2002 4:19 pm
Location: Uruguay -- Montevideo
Contact:

Post by AVATAr »

Maybe if you have mysql in both servers, you may have phpmyadmin installed too, so you can export it (it produces a large sql script) and then import it (executing that sql script).

maybe...
Post Reply