Table of Contents
回复讨论(解决方案)
Home Backend Development PHP Tutorial 求教,关于window服务器,mysql数据库备份问题

求教,关于window服务器,mysql数据库备份问题

Jun 23, 2016 pm 02:26 PM

本帖最后由 PerfectGet 于 2013-11-01 18:07:06 编辑

mysql数据库备份

我们服务器上跑了2个,一个IIS 一个WAMP集成,现在我们需要把WAMP删掉 换单独的WAMP配置, 现在需要把以前的网站备份, 我用DOS下 mysqldump 备份 老提示语法错误, 那我就用PHPMYADMIN吧, 可是localhost地址打不开提示403, 该怎么解决???还有一个问题就是我们需要wamp和IIS服务共存 共用80端口 有什么好办法??

回复讨论(解决方案)

wamp还没删吧,能进入phpmyadmin备份吗

用图形化工具也可以备份

你只不过是需要将继承 php 环境变换到分立环境,那么只需复制 mysql\data 目录到备份目录即可
你可以用 my.ini 指定 mysql 数据库目录,这样当更换 mysql 系统时就不必耽心数据丢失了

apache 和 iis 共存,可以有:
启用 apache 的路由功能,路由到 iis
通过 iis 的指派功能将 php 网站指派到 apache

其实并不需要弄什么共存,iis 一样能很好的支持 php

推荐工具navicat 只要能连上数据库就可以备份了

端口无法共存,只能一个用80,一个用8080之类的。

备份MySQL数据库,用工具进行export当然最好,也可以直接找到MySQL安装目录下的data目录,拷贝所有的数据库原始文件。

你只不过是需要将继承 php 环境变换到分立环境,那么只需复制 mysql\data 目录到备份目录即可
你可以用 my.ini 指定 mysql 数据库目录,这样当更换 mysql 系统时就不必耽心数据丢失了

apache 和 iis 共存,可以有:
启用 apache 的路由功能,路由到 iis
通过 iis 的指派功能将 php 网站指派到 apache

其实并不需要弄什么共存,iis 一样能很好的支持 php
是这样的, 我是想换个LAMP环境 那么是不是我只要这个 mysql\data  复制出来覆盖新环境的 这个目录, 然后再网站的配置更改数据库账号密码 ?你的通过 iis 的指派功能将 php 网站指派到 apache 不太懂..

第一个问题已解决 , 第二个问题 怎么解决??

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
1 months ago By 尊渡假赌尊渡假赌尊渡假赌
Two Point Museum: All Exhibits And Where To Find Them
1 months ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Working with Flash Session Data in Laravel Working with Flash Session Data in Laravel Mar 12, 2025 pm 05:08 PM

Laravel simplifies handling temporary session data using its intuitive flash methods. This is perfect for displaying brief messages, alerts, or notifications within your application. Data persists only for the subsequent request by default: $request-

cURL in PHP: How to Use the PHP cURL Extension in REST APIs cURL in PHP: How to Use the PHP cURL Extension in REST APIs Mar 14, 2025 am 11:42 AM

The PHP Client URL (cURL) extension is a powerful tool for developers, enabling seamless interaction with remote servers and REST APIs. By leveraging libcurl, a well-respected multi-protocol file transfer library, PHP cURL facilitates efficient execution of various network protocols, including HTTP, HTTPS, and FTP. This extension offers granular control over HTTP requests, supports multiple concurrent operations, and provides built-in security features.

Simplified HTTP Response Mocking in Laravel Tests Simplified HTTP Response Mocking in Laravel Tests Mar 12, 2025 pm 05:09 PM

Laravel provides concise HTTP response simulation syntax, simplifying HTTP interaction testing. This approach significantly reduces code redundancy while making your test simulation more intuitive. The basic implementation provides a variety of response type shortcuts: use Illuminate\Support\Facades\Http; Http::fake([ 'google.com' => 'Hello World', 'github.com' => ['foo' => 'bar'], 'forge.laravel.com' =>

12 Best PHP Chat Scripts on CodeCanyon 12 Best PHP Chat Scripts on CodeCanyon Mar 13, 2025 pm 12:08 PM

Do you want to provide real-time, instant solutions to your customers' most pressing problems? Live chat lets you have real-time conversations with customers and resolve their problems instantly. It allows you to provide faster service to your custom

Explain the concept of late static binding in PHP. Explain the concept of late static binding in PHP. Mar 21, 2025 pm 01:33 PM

Article discusses late static binding (LSB) in PHP, introduced in PHP 5.3, allowing runtime resolution of static method calls for more flexible inheritance.Main issue: LSB vs. traditional polymorphism; LSB's practical applications and potential perfo

PHP Logging: Best Practices for PHP Log Analysis PHP Logging: Best Practices for PHP Log Analysis Mar 10, 2025 pm 02:32 PM

PHP logging is essential for monitoring and debugging web applications, as well as capturing critical events, errors, and runtime behavior. It provides valuable insights into system performance, helps identify issues, and supports faster troubleshoot

HTTP Method Verification in Laravel HTTP Method Verification in Laravel Mar 05, 2025 pm 04:14 PM

Laravel simplifies HTTP verb handling in incoming requests, streamlining diverse operation management within your applications. The method() and isMethod() methods efficiently identify and validate request types. This feature is crucial for building

Discover File Downloads in Laravel with Storage::download Discover File Downloads in Laravel with Storage::download Mar 06, 2025 am 02:22 AM

The Storage::download method of the Laravel framework provides a concise API for safely handling file downloads while managing abstractions of file storage. Here is an example of using Storage::download() in the example controller:

See all articles