求教,关于window服务器,mysql数据库备份问题-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

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备份吗

用图形化工具也可以备份

推荐工具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

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

11 Best PHP URL Shortener Scripts (Free and Premium)Mar 03, 2025 am 10:49 AM

Long URLs, often cluttered with keywords and tracking parameters, can deter visitors. A URL shortening script offers a solution, creating concise links ideal for social media and other platforms. These scripts are valuable for individual websites a

Working with Flash Session Data in LaravelMar 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-

Build a React App With a Laravel Back End: Part 2, ReactMar 04, 2025 am 09:33 AM

This is the second and final part of the series on building a React application with a Laravel back-end. In the first part of the series, we created a RESTful API using Laravel for a basic product-listing application. In this tutorial, we will be dev

Simplified HTTP Response Mocking in Laravel TestsMar 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' =>

cURL in PHP: How to Use the PHP cURL Extension in REST APIsMar 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.

12 Best PHP Chat Scripts on CodeCanyonMar 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

Announcement of 2025 PHP Situation SurveyMar 03, 2025 pm 04:20 PM

The 2025 PHP Landscape Survey investigates current PHP development trends. It explores framework usage, deployment methods, and challenges, aiming to provide insights for developers and businesses. The survey anticipates growth in modern PHP versio

Notifications in LaravelMar 04, 2025 am 09:22 AM

In this article, we're going to explore the notification system in the Laravel web framework. The notification system in Laravel allows you to send notifications to users over different channels. Today, we'll discuss how you can send notifications ov

See all articles